<table>
<tr><th>1904</th><th>1904 Date System </th><th>22</th></tr>
<tr> <td>4 </td> <td>f1904</td> <td>2</td> <td>=1 if the 1904 date system is used</td></tr>
</table>

<table>
<tr><th>ADDIN</th><th>Workbook Is an Add-in Macro </th><th>87</th></tr>
</table>

<table>
<tr><th>PLOTAREA</th><th>Frame Belongs to Plot Area </th><th>1035</th></tr>
</table>

<table>
<tr><th>BEGIN</th><th>Defines the Beginning of an Object </th><th>1033</th></tr>
</table>

<table>
<tr><th>END</th><th>Defines the End of an Object </th><th>1034</th></tr>
</table>

<table>
<tr><th>ADDMENU</th><th>Menu Addition </th><th>C2</th></tr>
<tr> <td>4 </td> <td>icetabItem</td> <td>2</td> <td>icetab of the command</td></tr>
<tr> <td>6 </td> <td>icetabBefore</td> <td>2</td> <td>icetab of the existing command prior to where the new command was inserted</td></tr>
<tr> <td>8 </td> <td>caitm</td> <td>1</td> <td>Number of ADDMENU records at the next level of the menu hierarchy</td></tr>
<tr> <td>9 </td> <td>fInsert</td> <td>1</td> <td>=1, insert this menu object =0, this is a placeholder record</td></tr>
<tr> <td>10 </td> <td>rgch</td> <td>var</td> <td>stItem, stBefore, stMacro, stStatus, stHelp strings (see text)</td></tr>
</table>

<table>
<tr><th>ARRAY</th><th>Array-Entered Formula </th><th>221</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row of the array</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row of the array</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>1</td> <td>First column of the array</td></tr>
<tr> <td>9 </td> <td>colLast</td> <td>1</td> <td>Last column of the array</td></tr>
<tr> <td>10 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>12 </td> <td>chn</td> <td>4</td> <td>(See text)</td></tr>
<tr> <td>16 </td> <td>cce</td> <td>2</td> <td>Length of the parsed expression</td></tr>
<tr> <td>18 </td> <td>rgce</td> <td>var</td> <td>Parsed formula expression</td></tr>
</table>

<table>
<tr><th>AUTOFILTER</th><th>AutoFilter Data </th><th>9E</th></tr>
<tr> <td>4 </td> <td>iEntry</td> <td>2</td> <td>Index of the active AutoFilter</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>8 </td> <td>doper1</td> <td>10</td> <td>DOPER structure for the first filter condition</td></tr>
<tr> <td>18 </td> <td>doper2</td> <td>10</td> <td>DOPER structure for the second filter condition</td></tr>
<tr> <td>28 </td> <td>rgch</td> <td>var</td> <td>String storage for vtString DOPER</td></tr>
</table>

<table>
<tr><th>AUTOFILTER12</th><th>Auto-filter Data Introduced in Excel 2007 </th><th>87E</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =087Eh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>iEntry</td> <td>2</td> <td>The number of the column to which this filter applies, 0-based; stored as 2-byte integer number</td></tr>
</table>

<table>
<tr><th>AUTOFILTERINFO</th><th>Drop-Down Arrow Count </th><th>9D</th></tr>
<tr> <td>4 </td> <td>cEntries</td> <td>2</td> <td>Number of AutoFilter drop-down arrows on the sheet</td></tr>
</table>

<table>
<tr><th>AUTOWEBPUB</th><th>Auto web publish storage </th><th>8c0</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c0h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description</td></tr>
<tr> <td>16 </td> <td>tws</td> <td>1</td> <td>Type of web source</td></tr>
<tr> <td>17 </td> <td>grbitFlags</td> <td>2</td> <td>Flags</td></tr>
<tr> <td>19 </td> <td>id</td> <td>2</td> <td>Unused</td></tr>
<tr> <td>21 </td> <td>ref</td> <td>8</td> <td>REF structure; ref if twsREf</td></tr>
<tr> <td>29 </td> <td>cchPath</td> <td>2</td> <td>Where to save</td></tr>
<tr> <td>31 </td> <td>cchShTitle</td> <td>2</td> <td>Sheet title; 0 if twsWorkbook</td></tr>
<tr> <td>33 </td> <td>cchObjToPub</td> <td>2</td> <td>Object name, if applicable</td></tr>
<tr> <td>35 </td> <td>rgach</td> <td>var</td> <td>Path, sheet then object</td></tr>
</table>

<table>
<tr><th>BACKUP</th><th>Save Backup Version of the File </th><th>40</th></tr>
<tr> <td>4 </td> <td>fBackupFile</td> <td>2</td> <td>=1 if Excel should save a backup version of the file</td></tr>
</table>

<table>
<tr><th>BLANK</th><th>Cell Value, Blank Cell </th><th>201</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
</table>

<table>
<tr><th>BOF</th><th>Beginning of File </th><th>809</th></tr>
<tr> <td>4 </td> <td>vers</td> <td>2</td> <td>Version number: =0600 for BIFF8</td></tr>
<tr> <td>6 </td> <td>dt</td> <td>2</td> <td>Substream type: 0005h = Workbook globals 0006h = Visual Basic module 0010h = Worksheet or dialog sheet 0020h = Chart 0040h = Excel 4.0 macro sheet 0100h = Workspace file</td></tr>
<tr> <td>8 </td> <td>rupBuild</td> <td>2</td> <td>Build identifier (=0DBBh for Excel 97)</td></tr>
<tr> <td>10 </td> <td>rupYear</td> <td>2</td> <td>Build year (=07CCh for Excel 97)</td></tr>
<tr> <td>12 </td> <td>bfh</td> <td>4</td> <td>File history flags</td></tr>
<tr> <td>16 </td> <td>sfo</td> <td>4</td> <td>Lowest BIFF version (see text)</td></tr>
</table>

<table>
<tr><th>BOOKBOOL</th><th>Workbook Option Flag </th><th>DA</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>See table below</td></tr>
</table>

<table>
<tr><th>BOOKEXT</th><th>Extra Book Info </th><th>863</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0863h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Must be zero</td></tr>
<tr> <td>16 </td> <td>cb</td> <td>4</td> <td>Record size minus 4 (excludes rt and cb in record header) =014h in Excel 10, =015h in Excel 11, may be larger in future releases</td></tr>
<tr> <td>20 </td> <td>grbit</td> <td>4</td> <td>Flags and other fields; see description below</td></tr>
<tr> <td>24 </td> <td>grbit2</td> <td>var</td> <td>In Excel 11 this indicates there are more flags if it is set to 1. In Excel 10 this is 0. This field may be larger in the future.</td></tr>
</table>

<table>
<tr><th>BOOLERR</th><th>Cell Value, Boolean or Error </th><th>205</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
<tr> <td>10 </td> <td>bBoolErr</td> <td>1</td> <td>Boolean value or error value</td></tr>
<tr> <td>11 </td> <td>fError</td> <td>1</td> <td>Boolean/error flag</td></tr>
</table>

<table>
<tr><th>BOTTOMMARGIN</th><th>Bottom Margin Measurement </th><th>29</th></tr>
<tr> <td>4 </td> <td>num</td> <td>8</td> <td>Bottom margin</td></tr>
</table>

<table>
<tr><th>BOUNDSHEET</th><th>Sheet Information </th><th>85</th></tr>
<tr> <td>4 </td> <td>lbPlyPos</td> <td>4</td> <td>Stream position of the start of the BOF record for the sheet</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>10 </td> <td>cch</td> <td>1</td> <td>Length of the sheet name (in characters)</td></tr>
<tr> <td>11 </td> <td>rgch</td> <td>var</td> <td>Sheet name (grbit/rgb fields of Unicode String )</td></tr>
</table>

<table>
<tr><th>CALCCOUNT</th><th>Iteration Count </th><th>0C</th></tr>
<tr> <td>4 </td> <td>cIter</td> <td>2</td> <td>Iteration count</td></tr>
</table>

<table>
<tr><th>CALCMODE</th><th>Calculation Mode </th><th>0D</th></tr>
<tr> <td>4 </td> <td>fAutoRecalc</td> <td>2</td> <td>Calculation mode: =0 for manual =1 for automatic =1 for automatic, except tables</td></tr>
</table>

<table>
<tr><th>CELLWATCH</th><th>Cell Watch </th><th>86C</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =086Ch</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; =1 (bitfFrtRef); FRT header includes a REF structure</td></tr>
<tr> <td>8 </td> <td>refFrt</td> <td>8</td> <td>REF structure of cell being watched</td></tr>
<tr> <td>16 </td> <td>cb</td> <td>4</td> <td>Size of variable length rgb; =0 for Excel 10 and Excel 11, but is set up for extension and preservation of more data</td></tr>
<tr> <td>20 </td> <td>rgb</td> <td>var</td> <td>Extended info goes here. This is empty for Excel 10 and Excel 11, but is set up for extension and preservation of more data</td></tr>
</table>

<table>
<tr><th>CF</th><th>Conditional Formatting Conditions </th><th>1B1</th></tr>
<tr> <td>4 </td> <td>ct</td> <td>1</td> <td>Conditional Formatting type 1 = "Cell Value Is" 2 = "Formula Is"</td></tr>
<tr> <td>5 </td> <td>cp</td> <td>1</td> <td>Conditional Formatting operator (applicable when ct=1) 1 = "between" 2 = "not between" 3 = "equal" 4 = "not equal" 5 = "greater than" 6 = "less than" 7 = "greater than or equal" 8 = "less than or equal"</td></tr>
<tr> <td>6 </td> <td>cce1</td> <td>2</td> <td>Count of bytes in rgce1</td></tr>
<tr> <td>8 </td> <td>cce2</td> <td>2</td> <td>Count of bytes in rgce2</td></tr>
<tr> <td>10 </td> <td>rgbdxf</td> <td>var</td> <td>Conditional format to apply, stored as a DXF</td></tr>
<tr> <td>var </td> <td>rgce1</td> <td>var</td> <td>First formula for this condition</td></tr>
</table>

<table>
<tr><th>CF12</th><th>Conditional Formatting Condition 12 </th><th>87A</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =087Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>ct</td> <td>1</td> <td>Conditional Formatting type 1 = "Cell Value Is" 2 = "Formula Is" 3 = Gradient 4 = Databar 5 = Filter 6 = Multistate (KPI)</td></tr>
<tr> <td>17 </td> <td>cp</td> <td>1</td> <td>Conditional Formatting operator (when ct=1) 1 = "between" 2 = "not between" 3 = "equal" 4 = "not equal" 5 = "greater than" 6 = "less than" 7 = "greater than or equal" 8 = "less than or equal"</td></tr>
<tr> <td>18 </td> <td>cce1</td> <td>2</td> <td>Count of bytes in rgce1</td></tr>
<tr> <td>20 </td> <td>cce2</td> <td>2</td> <td>Count of bytes in rgce2</td></tr>
<tr> <td>22 </td> <td>rgbdxf</td> <td>var</td> <td>Conditional format to apply, stored as a DXF</td></tr>
<tr> <td>var </td> <td>rgce1</td> <td>var</td> <td>First formula for this condition</td></tr>
<tr> <td>var </td> <td>rgce2</td> <td>var</td> <td>Second formula for this condition</td></tr>
<tr> <td>var </td> <td>cce3</td> <td>2</td> <td>Count of bytes in rgce3</td></tr>
<tr> <td>var </td> <td>rgce3</td> <td>var</td> <td>Third formula if needed</td></tr>
<tr> <td>var </td> <td>grbitCF12</td> <td>1</td> <td>see text below</td></tr>
<tr> <td>var </td> <td>ipriority</td> <td>2</td> <td>condition priority</td></tr>
<tr> <td>var </td> <td>icfTemplate</td> <td>2</td> <td>template index</td></tr>
<tr> <td>var </td> <td>cbTemplateParm</td> <td>1</td> <td>count of template bytes to follow (<=16)</td></tr>
<tr> <td>var </td> <td>rgbTemplateParm</td> <td>var</td> <td>template parameter bytes</td></tr>
<tr> <td>var </td> <td>rgbCT</td> <td>var</td> <td>type specific content follows; see text</td></tr>
</table>

<table>
<tr><th>CFEX</th><th>Conditional Formatting Extension </th><th>87B</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =087Bh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>fIsCF12</td> <td>4</td> <td>if non-zero this is an Office Excel 2007-specific CF</td></tr>
<tr> <td>20 </td> <td>nID</td> <td>2</td> <td>Unique ID of parent CONDFMT</td></tr>
<tr> <td>22 </td> <td>rgbExt</td> <td>var</td> <td>only present if fIsCF12 = 0</td></tr>
</table>

<table>
<tr><th>CODENAME</th><th>VBE Object Name </th><th>1BA</th></tr>
<tr> <td>4 </td> <td>stCodeName</td> <td>var</td> <td>The name as a Unicode String .</td></tr>
</table>

<table>
<tr><th>CODEPAGE</th><th>Default Code Page </th><th>42</th></tr>
<tr> <td>4 </td> <td>cv</td> <td>2</td> <td>Code page the file is saved in: 01B5h (437 dec.) = IBM PC (Multiplan) 8000h (32768 dec.) = Apple Macintosh 04E4h (1252 dec.) = ANSI (Microsoft Windows)</td></tr>
</table>

<table>
<tr><th>COLINFO</th><th>Column Formatting Information </th><th>7D</th></tr>
<tr> <td>4 </td> <td>colFirst</td> <td>2</td> <td>First formatted column (0-based)</td></tr>
<tr> <td>6 </td> <td>colLast</td> <td>2</td> <td>Last formatted column (0-based)</td></tr>
<tr> <td>8 </td> <td>coldx</td> <td>2</td> <td>Column width, in 1/256s of a character width</td></tr>
<tr> <td>10 </td> <td>ixfe</td> <td>2</td> <td>Index to XF record that contains the default format for the column.</td></tr>
<tr> <td>12 </td> <td>grbit</td> <td>2</td> <td>Options</td></tr>
<tr> <td>14 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be 0 (zero)</td></tr>
</table>

<table>
<tr><th>COMPAT12</th><th>Compatibility Checker 12 </th><th>88C</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Ch</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>fNoCompatChk</td> <td>4</td> <td>If non-zero dont call compatibility checker on BIFF8 save</td></tr>
</table>

<table>
<tr><th>COMPRESSPICTURES</th><th>Automatic Picture Compression Mode </th><th>89B</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =089Bh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>fAutoCompressPictures</td> <td>4</td> <td>=1 if pictures must be compressed for the current workbook. Stored as 4-byte integer value</td></tr>
</table>

<table>
<tr><th>CONDFMT</th><th>Conditional Formatting Range Information </th><th>1B0</th></tr>
<tr> <td>4 </td> <td>ccf</td> <td>2</td> <td>Number of conditional formats</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>8 </td> <td>rwFirst</td> <td>2</td> <td>First row to conditionally format (0-based)</td></tr>
<tr> <td>10 </td> <td>rwLast</td> <td>2</td> <td>Last row to conditionally format (0-based)</td></tr>
<tr> <td>12 </td> <td>colFirst</td> <td>2</td> <td>First column to conditionally format (0-based)</td></tr>
<tr> <td>14 </td> <td>colLast</td> <td>2</td> <td>Last column to conditionally format (0-based)</td></tr>
<tr> <td>16 </td> <td>rgbSqref</td> <td>var</td> <td>Array of sqref structures</td></tr>
</table>

<table>
<tr><th>CONDFMT12</th><th>Conditional Formatting Range Information 12 </th><th>879</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0879h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>ccf</td> <td>2</td> <td>Number of CF12 records to follow</td></tr>
<tr> <td>18 </td> <td>grbitCF</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>20 </td> <td>rwFirst</td> <td>2</td> <td>First row to conditionally format (0-based)</td></tr>
<tr> <td>22 </td> <td>rwLast</td> <td>2</td> <td>Last row to conditionally format (0-based)</td></tr>
<tr> <td>24 </td> <td>colFirst</td> <td>2</td> <td>First column to conditionally format (0-based)</td></tr>
<tr> <td>26 </td> <td>colLast</td> <td>2</td> <td>Last column to conditionally format (0-based)</td></tr>
<tr> <td>28 </td> <td>rgbSqref</td> <td>var</td> <td>Array of sqref structures</td></tr>
</table>

<table>
<tr><th>CONTINUE</th><th>Continues Long Records </th><th>3C</th></tr>
<tr> <td>4 </td> <td>data</td> <td>var</td> <td>Continuation of record data</td></tr>
</table>

<table>
<tr><th>CONTINUEFRT</th><th>Continued FRT </th><th>812</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0812h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>rgb</td> <td>var</td> <td>Continued data</td></tr>
</table>

<table>
<tr><th>CONTINUEFRT11</th><th>Continue FRT 11 </th><th>875</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0875h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags;</td></tr>
<tr> <td>8 </td> <td>Ref</td> <td>8</td> <td>The rectangle range (see table below for bits definition)</td></tr>
<tr> <td>16 </td> <td>Rgb</td> <td>var</td> <td>Continued data</td></tr>
</table>

<table>
<tr><th>CONTINUEFRT12</th><th>Continued FRT 12 </th><th>87F</th></tr>
</table>

<table>
<tr><th>COORDLIST</th><th>Polygon Object Vertex Coordinates </th><th>A9</th></tr>
<tr> <td>4 </td> <td>rgVTX</td> <td>var</td> <td>Array of vertex coordinates</td></tr>
</table>

<table>
<tr><th>COUNTRY</th><th>Default Country and WIN.INI Country </th><th>8C</th></tr>
<tr> <td>4 </td> <td>iCountryDef</td> <td>2</td> <td>Default country index</td></tr>
<tr> <td>6 </td> <td>iCountryWinIni</td> <td>2</td> <td>Country index from the Win.ini file</td></tr>
</table>

<table>
<tr><th>CRASHRECERR</th><th>Crash Recovery Error </th><th>865</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0865h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Must be zero</td></tr>
<tr> <td>16 </td> <td>cb</td> <td>4</td> <td>Fixed size of this record minus 4 bytes for BIFF header (rt and cb), plus only 1 byte from rgch. =13h</td></tr>
<tr> <td>20 </td> <td>cch</td> <td>2</td> <td>Length of the string containing error message(s); number of actual characters.</td></tr>
<tr> <td>22 </td> <td>rgch</td> <td>var</td> <td>String containing localized text of one or more line(s) of crash recovery error message(s). (See section titled Unicode Strings in Biff8 for more information about Unicode encodings.)</td></tr>
</table>

<table>
<tr><th>CRN</th><th>Nonresident Operands </th><th>5A</th></tr>
<tr> <td>4 </td> <td>colLast</td> <td>1</td> <td>Last column of the nonresident operand</td></tr>
<tr> <td>5 </td> <td>colFirst</td> <td>1</td> <td>First column of the nonresident operand</td></tr>
<tr> <td>6 </td> <td>rw</td> <td>2</td> <td>Row of the nonresident operand</td></tr>
<tr> <td>8 </td> <td>OPER</td> <td>var</td> <td>OPER structure; see the following description</td></tr>
</table>

<table>
<tr><th>CRTCOOPT</th><th>Color options for Chart series in Mac Office 11 </th><th>8cb</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c9h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>padding</td> <td>8</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>iScheme</td> <td>4</td> <td>Color Scheme</td></tr>
<tr> <td>20 </td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
</table>

<table>
<tr><th>DATALABEXT</th><th>Chart Data Label Extension </th><th>86A</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =086Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>DATALABEXTCONTENTS</th><th>Chart Data Label Extension Contents </th><th>86B</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =086Bh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>grbit</td> <td>2</td> <td>Option flags for chart data labels (see description below)</td></tr>
<tr> <td>18 </td> <td>cchSep</td> <td>2</td> <td>Count of characters in the separator string</td></tr>
<tr> <td>20 </td> <td>rgchSep</td> <td>var</td> <td>Separator string for use in chart data labels. (See section titled Unicode Strings in Biff8 for more information about Unicode encodings.)</td></tr>
</table>

<table>
<tr><th>DBCELL</th><th>Stream Offsets </th><th>D7</th></tr>
<tr> <td>4 </td> <td>dbRtrw</td> <td>4</td> <td>Offset from the start of the DBCELL record to the start of the first ROW record in the block; this is an offset to an earlier position in the stream.</td></tr>
<tr> <td>8 </td> <td>rgdb</td> <td>var</td> <td>Array of stream offsets (2 bytes each).</td></tr>
</table>

<table>
<tr><th>DBQUERYEXT</th><th>Database Query Extensions </th><th>803</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0803h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>dbt</td> <td>2</td> <td>The database type; this overrides the value of dbt in the SXEXT record 1= ODBC data source 2= DAO recordset 4= Web Query XL9: 5= OLE database XL9: 6= Text query XL9: 7= ADO query XL10: 8= (reserved) XL11: 9= Data retrieval service</td></tr>
<tr> <td>10 </td> <td>grbitDbquery</td> <td>4</td> <td>DB Query options; see following table</td></tr>
<tr> <td>14 </td> <td>grbitExt</td> <td>2</td> <td>Extended options; see following table</td></tr>
<tr> <td>16 </td> <td>bVerDbqueryEdit</td> <td>1</td> <td>The last version of Excel that edited the query 0= Excel 2000 1= Excel XP 2= Office Excel 2003 3=Office Excel 2007</td></tr>
<tr> <td>17 </td> <td>bVerdbqueryRefreshed</td> <td>1</td> <td>The last version of Excel that refreshed the query (see bVerDbqueryEdit for values)</td></tr>
<tr> <td>18 </td> <td>bVerDbqueryRefreshableMin</td> <td>1</td> <td>The oldest version of Excel that is enabled to refresh the query (see bVerDbqueryEdit for values)</td></tr>
<tr> <td>19 </td> <td>(Reserved)</td> <td>3</td> <td>Reserved; must be zero</td></tr>
<tr> <td>22 </td> <td>coledb</td> <td>2</td> <td>Count of OLE DB connection strings; each is saved as an OLEDBCONN record immediately following the DBQUERYEXT record</td></tr>
<tr> <td>24 </td> <td>cstFuture</td> <td>2</td> <td>Count of strings from future versions of Excel; each is saved as an EXTSTRING record immediately following the OLEDBCONN records</td></tr>
<tr> <td>26 </td> <td>wRefreshInterval</td> <td>2</td> <td>0= Timed refresh is off for this query; any other value is the time between refreshes measured in minutes</td></tr>
<tr> <td>28 </td> <td>wHtmlFormat</td> <td>2</td> <td>HTML formatting to apply to the imported data for a Web Query; 1= None 2= Rich Text Formatting 3= Full HTML formatting</td></tr>
<tr> <td>30 </td> <td>cwParamFlags</td> <td>2</td> <td>Count of pbt flag sets in rgpbt; these override the flags from the PARAMQRY record</td></tr>
<tr> <td>32 </td> <td>rgpbt</td> <td>var</td> <td>Array of pbt flags; each is 2 bytes; see following table</td></tr>
<tr> <td>var </td> <td>rgbFuture</td> <td>var</td> <td>Information from future versions of Excel</td></tr>
</table>

<table>
<tr><th>DCON</th><th>Data Consolidation Information </th><th>50</th></tr>
<tr> <td>4 </td> <td>iiftab</td> <td>2</td> <td>Index to the data consolidation function (see the following table)</td></tr>
<tr> <td>6 </td> <td>fLeftCat</td> <td>2</td> <td>=1 if the Left Column option is turned on</td></tr>
<tr> <td>8 </td> <td>fTopCat</td> <td>2</td> <td>=1 if the Top Row option is turned on</td></tr>
<tr> <td>10 </td> <td>fLinkConsol</td> <td>2</td> <td>=1 if the Create Links To Source Data option is turned on</td></tr>
</table>

<table>
<tr><th>DCONBIN</th><th>Data Consolidation Information </th><th>1B5</th></tr>
<tr> <td>4 </td> <td>cchName</td> <td>1</td> <td>Length of the named range of the source area</td></tr>
<tr> <td>5 </td> <td>stName</td> <td>var</td> <td>Named range of the source area for consolidation</td></tr>
<tr> <td>var </td> <td>cchFile</td> <td>1</td> <td>Length of the workbook name</td></tr>
<tr> <td>var </td> <td>stFile</td> <td>var</td> <td>Workbook name</td></tr>
</table>

<table>
<tr><th>DCONN</th><th>Data Connection </th><th>876</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0876h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>Dbt</td> <td>2</td> <td>Database source types (see below for details)</td></tr>
<tr> <td>10 </td> <td>Grbit</td> <td>2</td> <td>Connection flags (see below for details)</td></tr>
<tr> <td>12 </td> <td>Cparams</td> <td>2</td> <td>The number of parameters for parameterized queries</td></tr>
<tr> <td>14 </td> <td>(Reserved)</td> <td>2</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitDbquery</td> <td>2</td> <td>Query flags (see below for details)</td></tr>
<tr> <td>18 </td> <td>grbitDbt</td> <td>2</td> <td>Query flags specific to the dbt (see below for details)</td></tr>
<tr> <td>20 </td> <td>bVerDbqueryEdit</td> <td>1</td> <td>The Excel query version that was last used to edit the query. One of the following version numbers: =0 Excel 9 (2000) and earlier =1 Excel 10 (XP) =2 Excel 11 (2003) =3 Excel 12 (2007)</td></tr>
<tr> <td>21 </td> <td>bVerDbqueryRefreshed</td> <td>1</td> <td>The Excel query version that last refreshed the query. One of the following version numbers: =0 Excel 9 (2000) and earlier =1 Excel 10 (XP) =2 Excel 11 (2003) =3 Excel 12 (2007)</td></tr>
<tr> <td>22 </td> <td>bVerDbqueryRefreshableMin</td> <td>1</td> <td>Minimum Excel query version required to refresh the query. One of the following version numbers: =0 Excel 9 (2000) and earlier =1 Excel 10 (XP) =2 Excel 11 (2003) =3 Excel 12 (2007)</td></tr>
</table>

<table>
<tr><th>DCONNAME</th><th>Data Consolidation Named References </th><th>52</th></tr>
<tr> <td>4 </td> <td>cchName</td> <td>1</td> <td>Length of the named range of the source area</td></tr>
<tr> <td>5 </td> <td>stName</td> <td>var</td> <td>Named range of the source area for consolidation</td></tr>
<tr> <td>var </td> <td>cchFile</td> <td>1</td> <td>Length of the workbook name</td></tr>
<tr> <td>var </td> <td>stFile</td> <td>var</td> <td>Workbook name</td></tr>
</table>

<table>
<tr><th>DCONREF</th><th>Data Consolidation References </th><th>51</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row of the source area for consolidation</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row of the source area for consolidation</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>1</td> <td>First column of the source area for consolidation</td></tr>
<tr> <td>9 </td> <td>colLast</td> <td>1</td> <td>Last column of the source area for consolidation</td></tr>
<tr> <td>10 </td> <td>cch</td> <td>1</td> <td>Length of the workbook name</td></tr>
<tr> <td>11 </td> <td>rgch</td> <td>1</td> <td>Workbook name</td></tr>
</table>

<table>
<tr><th>DEFAULTROWHEIGHT</th><th>Default Row Height </th><th>225</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags (see the following table)</td></tr>
<tr> <td>6 </td> <td>miyRw</td> <td>2</td> <td>Default row height</td></tr>
</table>

<table>
<tr><th>DEFCOLWIDTH</th><th>Default Width for Columns </th><th>55</th></tr>
<tr> <td>4 </td> <td>cchdefColWidth</td> <td>2</td> <td>Default width of the columns</td></tr>
</table>

<table>
<tr><th>DELMENU</th><th>Menu Deletion </th><th>C3</th></tr>
<tr> <td>4 </td> <td>icetabItem</td> <td>2</td> <td>icetab of the command</td></tr>
<tr> <td>6 </td> <td>cditm</td> <td>1</td> <td>Number of DELMENU records at the next level of the menu hierarchy</td></tr>
<tr> <td>7 </td> <td>fDelete</td> <td>1</td> <td>=1, delete this menu object =0, this is a placeholder record</td></tr>
<tr> <td>8 </td> <td>fMultiple</td> <td>1</td> <td>=1 if this item has subitems</td></tr>
<tr> <td>9 </td> <td>rgch</td> <td>var</td> <td>stItem (see text)</td></tr>
</table>

<table>
<tr><th>DELTA</th><th>Iteration Increment </th><th>10</th></tr>
<tr> <td>4 </td> <td>numDelta</td> <td>8</td> <td>Maximum iteration change</td></tr>
</table>

<table>
<tr><th>DIMENSIONS</th><th>Cell Table Size </th><th>200</th></tr>
<tr> <td>4 </td> <td>rwMic</td> <td>4</td> <td>First defined row on the sheet</td></tr>
<tr> <td>8 </td> <td>rwMac</td> <td>4</td> <td>Last defined row on the sheet, plus 1</td></tr>
<tr> <td>12 </td> <td>colMic</td> <td>2</td> <td>First defined column on the sheet</td></tr>
<tr> <td>14 </td> <td>colMac</td> <td>2</td> <td>Last defined column on the sheet, plus 1</td></tr>
<tr> <td>16 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be 0 (zero)</td></tr>
</table>

<table>
<tr><th>DOCROUTE</th><th>Routing Slip Information </th><th>B8</th></tr>
<tr> <td>4 </td> <td>iStage</td> <td>2</td> <td>Routing stage</td></tr>
<tr> <td>6 </td> <td>cRecip</td> <td>2</td> <td>Number of recipients</td></tr>
<tr> <td>8 </td> <td>delOption</td> <td>2</td> <td>Delivery option: =0, one at a time =1, all at once</td></tr>
</table>

<table>
<tr><th>DROPDOWNOBJIDS</th><th>Drop Down Object IDs Record </th><th>874</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0874h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag =0 bitFrtNone</td></tr>
</table>

<table>
<tr><th>DSF</th><th>Double Stream File </th><th>161</th></tr>
<tr> <td>4 </td> <td>fDSF</td> <td>2</td> <td>=1 if the workbook is a double stream file</td></tr>
</table>

<table>
<tr><th>DV</th><th>Data Validation Criteria </th><th>1BE</th></tr>
<tr> <td>4 </td> <td>dwDvFlags</td> <td>4</td> <td>Option flags; see following table</td></tr>
<tr> <td>8 </td> <td>rgb</td> <td>var</td> <td>Array of data validation criteria (see text) followed by Title, Prompt, and Error sts, Min and Max rgces, and cref REFs</td></tr>
</table>

<table>
<tr><th>DVAL</th><th>Data Validation Information </th><th>1B2</th></tr>
<tr> <td>4 </td> <td>wDviFlags</td> <td>2</td> <td>Option flags; see following table</td></tr>
<tr> <td>6 </td> <td>xLeft</td> <td>4</td> <td>The x coordinate of the input window</td></tr>
<tr> <td>10 </td> <td>yTop</td> <td>4</td> <td>The y coordinate of the input window</td></tr>
<tr> <td>14 </td> <td>idObj</td> <td>4</td> <td>For a Table with in-cell drop-down, the object id of drop-down OBJ record</td></tr>
<tr> <td>18 </td> <td>idvMac</td> <td>4</td> <td>Number of DV records that follow</td></tr>
</table>

<table>
<tr><th>DXF</th><th>Differential XF </th><th>88D</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Dh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitDxf</td> <td>2</td> <td>see table below</td></tr>
<tr> <td>18 </td> <td>xfProps</td> <td>var</td> <td>Array of formatting properties; see table below</td></tr>
</table>

<table>
<tr><th>EDG</th><th>Edition Globals </th><th>88</th></tr>
<tr> <td>4 </td> <td>lcsec</td> <td>4</td> <td>Count of all section records ever created in this document, plus 1 (includes published embedded charts)</td></tr>
<tr> <td>8 </td> <td>crtpub</td> <td>2</td> <td>Count of all PUB records in the file (includes published embedded charts)</td></tr>
</table>

<table>
<tr><th>EOF</th><th>End of File </th><th>0A</th></tr>
</table>

<table>
<tr><th>EXTERNCOUNT</th><th>Number of External References </th><th>16</th></tr>
<tr> <td>4 </td> <td>cxals</td> <td>2</td> <td>Number of external references</td></tr>
</table>

<table>
<tr><th>EXTERNNAME</th><th>Externally Referenced Name </th><th>223</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be 0 (zero)</td></tr>
<tr> <td>10 </td> <td>cch</td> <td>1</td> <td>Length of the external name</td></tr>
<tr> <td>11 </td> <td>rgch</td> <td>var</td> <td>External name</td></tr>
<tr> <td>var </td> <td>cce</td> <td>2</td> <td>Length of the name definition</td></tr>
<tr> <td>var </td> <td>rgce</td> <td>var</td> <td>Name definition, in parsed expression format; for more information, see Microsoft Excel Formulas .</td></tr>
</table>

<table>
<tr><th>EXTERNSHEET</th><th>External Reference </th><th>17</th></tr>
<tr> <td>4 </td> <td>cXTI</td> <td>2</td> <td>Number of XTI structures that follow</td></tr>
<tr> <td>6 </td> <td>rgXTI</td> <td>var</td> <td>Array of XTI structures</td></tr>
</table>

<table>
<tr><th>EXTSST</th><th>Extended Shared String Table </th><th>FF</th></tr>
<tr> <td>4 </td> <td>Dsst</td> <td>2</td> <td>Number of strings in each bucket</td></tr>
<tr> <td>6 </td> <td>Rgisstinf</td> <td>var</td> <td>Array of ISSTINF structures</td></tr>
</table>

<table>
<tr><th>EXTSTRING</th><th>FRT String </th><th>804</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0804h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>cch</td> <td>2</td> <td>Count of characters in the string</td></tr>
<tr> <td>10 </td> <td>rgach</td> <td>var</td> <td>string (grbit/rgb fields as defined in Unicode Strings in BIFF8 .)</td></tr>
</table>

<table>
<tr><th>FEAT</th><th>Shared Feature Record </th><th>868</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0868h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag (see table below)</td></tr>
<tr> <td>8 </td> <td>Ref</td> <td>8</td> <td>Range reference to a worksheet cell region if grbitFrt=1 (bitFrtRef). Otherwise blank.</td></tr>
<tr> <td>16 </td> <td>isf</td> <td>2</td> <td>Shared feature type index (see table below for possible values). =2 for Enhanced Protection =4 for SmartTag</td></tr>
<tr> <td>18 </td> <td>fHdr</td> <td>1</td> <td>=0 since this is for feat not feat header</td></tr>
<tr> <td>19 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved for future use =0 for Enhanced Protection or SmartTag</td></tr>
<tr> <td>23 </td> <td>cref</td> <td>2</td> <td>Count of ref ranges this feature is on</td></tr>
<tr> <td>25 </td> <td>cbFeatData</td> <td>4</td> <td>Count of byte for the current feature data</td></tr>
<tr> <td>29 </td> <td>(Reserved)</td> <td>2</td> <td>=0, currently not used</td></tr>
<tr> <td>31 </td> <td>REFs</td> <td>8</td> <td>REFs are written if cref!=0.</td></tr>
<tr> <td>var </td> <td>rgbFeat</td> <td>var</td> <td>Variable length byte of feature specific data (see section below for detail FEAT structures of each shared feature type)</td></tr>
</table>

<table>
<tr><th>FEAT11</th><th>Shared Feature 11 Record </th><th>872</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0872h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag (see table below for details)</td></tr>
<tr> <td>8 </td> <td>Ref</td> <td>8</td> <td>Range reference to a worksheet cell region if grbitFrt=1 (bitFrtRef). Otherwise blank.</td></tr>
<tr> <td>16 </td> <td>isf</td> <td>2</td> <td>Shared feature type index =5 for Table</td></tr>
<tr> <td>18 </td> <td>fHdr</td> <td>1</td> <td>=0 since this is for feat not feat header</td></tr>
<tr> <td>19 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved for future use =0 for Table</td></tr>
<tr> <td>23 </td> <td>cref</td> <td>2</td> <td>Count of ref ranges this feature is on</td></tr>
<tr> <td>25 </td> <td>cbFeatData</td> <td>4</td> <td>Count of byte for the current feature data.</td></tr>
<tr> <td>29 </td> <td>(Reserved)</td> <td>2</td> <td>=0 currently not used</td></tr>
<tr> <td>31 </td> <td>rgbFeat</td> <td>var</td> <td>Variable length byte of feature specific data (see section below for detail FEAT structures of each shared feature type)</td></tr>
</table>

<table>
<tr><th>FEAT12</th><th>Shared Feature 12 Record </th><th>878</th></tr>
</table>

<table>
<tr><th>FEATHEADR</th><th>Shared Feature Header </th><th>867</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0867h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used and set to 0.</td></tr>
<tr> <td>16 </td> <td>isf</td> <td>2</td> <td>Shared feature type index =2 for Enhanced Protection =4 for SmatTag</td></tr>
<tr> <td>18 </td> <td>fHdr</td> <td>1</td> <td>=1 since this is a feat header</td></tr>
<tr> <td>19 </td> <td>cbHdrData</td> <td>4</td> <td>Size of rgbHdrSData =4 for simple feature headers =0 there is no rgbHdrData =-1 for complex feature headers, the size of rgbHdrData depends on the isf type. (prior to Excel 2003, all features saved using FEATHEAER use complex features.)</td></tr>
<tr> <td>23 </td> <td>rgbHdrData</td> <td>var</td> <td>Byte array of extra info, including from future versions of Excel</td></tr>
</table>

<table>
<tr><th>FEATHEADR11</th><th>Shared Feature Header 11 </th><th>871</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0871h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag =0 bitFrtNone</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>isf</td> <td>2</td> <td>Shared feature type index =5 for Table</td></tr>
<tr> <td>18 </td> <td>fHdr</td> <td>1</td> <td>=1 since this is a feat header</td></tr>
<tr> <td>19 </td> <td>cbHdrData</td> <td>4</td> <td>Size of rgbHdrSData =4 for simple feature headers =0 there is no rgbHdrData =-1 for complex feature headers and the size of rgbHdrData depends on the isf type. (in Excel 2003, all features saved using FEATHEAER11 are complex features.)</td></tr>
<tr> <td>23 </td> <td>rgbHdrData</td> <td>var</td> <td>Byte array of extra info, including from future versions of Excel; length depends on isf feature type.</td></tr>
</table>

<table>
<tr><th>FEATINFO</th><th>Shared Feature Info Record </th><th>86d</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =086dh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0.</td></tr>
<tr> <td>16 </td> <td>Isf</td> <td>4</td> <td>The shared feature type =2 for Enhanced Protection =4 for SmartTag</td></tr>
<tr> <td>20 </td> <td>grbitFlags</td> <td>4</td> <td>Bit flags of handling instructions</td></tr>
</table>

<table>
<tr><th>FEATINFO11</th><th>Shared Feature Info 11 Record </th><th>873</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0873h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0.</td></tr>
<tr> <td>16 </td> <td>Isf</td> <td>4</td> <td>The shared feature type =5 for Table</td></tr>
<tr> <td>20 </td> <td>grbitFlags</td> <td>4</td> <td>Bit flags of handling instructions (see table below).</td></tr>
</table>

<table>
<tr><th>FILEPASS</th><th>File Is Password-Protected </th><th>2F</th></tr>
<tr> <td>4 </td> <td>wProtPass</td> <td>4</td> <td>Encrypted password</td></tr>
</table>

<table>
<tr><th>FILESHARING</th><th>File-Sharing Information </th><th>5B</th></tr>
<tr> <td>4 </td> <td>fReadOnlyRec</td> <td>2</td> <td>=1 if the Read Only Recommended option is selected in the Options dialog box</td></tr>
<tr> <td>6 </td> <td>wResPass</td> <td>2</td> <td>Encrypted password (if this field is 0 (zero), there is no write reservation password)</td></tr>
<tr> <td>8 </td> <td>cch</td> <td>1</td> <td>Length of the user name</td></tr>
<tr> <td>9 </td> <td>stUNWriteRes</td> <td>var</td> <td>User name</td></tr>
</table>

<table>
<tr><th>FILESHARING2</th><th>File-Sharing Information for Shared Lists </th><th>1A5</th></tr>
<tr> <td>4 </td> <td>fReadOnlyRec</td> <td>2</td> <td>=1 if the Read Only Recommended option is selected in the Options dialog box</td></tr>
<tr> <td>6 </td> <td>wResPass</td> <td>2</td> <td>Encrypted password (if this field is 0 (zero), there is no write reservation password)</td></tr>
<tr> <td>8 </td> <td>cch</td> <td>1</td> <td>Length of the user name</td></tr>
<tr> <td>9 </td> <td>stUNWriteRes</td> <td>var</td> <td>User name</td></tr>
</table>

<table>
<tr><th>FILTERMODE</th><th>Sheet Contains Filtered List </th><th>9B</th></tr>
</table>

<table>
<tr><th>FMQRY</th><th>Filemaker queries </th><th>8c6</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c5h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>4</td> <td>Flags</td></tr>
<tr> <td>12 </td> <td>cchName</td> <td>2</td> <td></td></tr>
<tr> <td>14 </td> <td>rgchName</td> <td>var</td> <td></td></tr>
</table>

<table>
<tr><th>FMSQRY</th><th>Filemaker queries </th><th>8c7</th></tr>
</table>

<table>
<tr><th>FNGRP12</th><th>Function Group </th><th>898</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0898h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>astFnGrp</td> <td>var</td> <td>Function group name; ASCII string</td></tr>
</table>

<table>
<tr><th>FNGROUPCOUNT</th><th>Built-in Function Group Count </th><th>9C</th></tr>
<tr> <td>4 </td> <td>cFnGroup</td> <td>2</td> <td>Number of built-in function groups</td></tr>
</table>

<table>
<tr><th>FNGROUPNAME</th><th>Function Group Name </th><th>9A</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>1</td> <td>Size of the function category name</td></tr>
<tr> <td>5 </td> <td>rgch</td> <td>var</td> <td>Function category name</td></tr>
</table>

<table>
<tr><th>FONT</th><th>Font Description </th><th>231</th></tr>
<tr> <td>4 </td> <td>dyHeight</td> <td>2</td> <td>Height of the font (in units of 1/20th of a point).</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>Font attributes (see the following table).</td></tr>
<tr> <td>8 </td> <td>icv</td> <td>2</td> <td>Index to the color palette.</td></tr>
<tr> <td>10 </td> <td>bls</td> <td>2</td> <td>Bold style; a number from 100dec to 1000dec (64h to 3E8h) that indicates the character weight (boldness). The default values are 190h for normal text and 2BCh for bold text.</td></tr>
<tr> <td>12 </td> <td>sss</td> <td>2</td> <td>Superscript/subscript: 00h= None 01h= Superscript 02h= Subscript</td></tr>
<tr> <td>14 </td> <td>uls</td> <td>1</td> <td>Underline style: 00h= None 01h= Single 02h= Double 21h= Single Accounting 22h= Double Accounting</td></tr>
<tr> <td>15 </td> <td>bFamily</td> <td>1</td> <td>Font family, as defined by the Windows API LOGFONT structure.</td></tr>
<tr> <td>16 </td> <td>bCharSet</td> <td>1</td> <td>Character set, as defined by the Windows API LOGFONT structure.</td></tr>
<tr> <td>17 </td> <td>(Reserved)</td> <td>1</td> <td>Reserved; must be 0 (zero).</td></tr>
<tr> <td>18 </td> <td>cch</td> <td>1</td> <td>Length of the font name.</td></tr>
<tr> <td>19 </td> <td>rgch</td> <td>var</td> <td>Font name.</td></tr>
</table>

<table>
<tr><th>FONT</th><th>Font Description </th><th>31</th></tr>
<tr> <td>4 </td> <td>dyHeight</td> <td>2</td> <td>Height of the font (in units of 1/20th of a point).</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>Font attributes (see the following table).</td></tr>
<tr> <td>8 </td> <td>icv</td> <td>2</td> <td>Index to the color palette.</td></tr>
<tr> <td>10 </td> <td>bls</td> <td>2</td> <td>Bold style; a number from 100dec to 1000dec (64h to 3E8h) that indicates the character weight (boldness). The default values are 190h for normal text and 2BCh for bold text.</td></tr>
<tr> <td>12 </td> <td>sss</td> <td>2</td> <td>Superscript/subscript: 00h= None 01h= Superscript 02h= Subscript</td></tr>
<tr> <td>14 </td> <td>uls</td> <td>1</td> <td>Underline style: 00h= None 01h= Single 02h= Double 21h= Single Accounting 22h= Double Accounting</td></tr>
<tr> <td>15 </td> <td>bFamily</td> <td>1</td> <td>Font family, as defined by the Windows API LOGFONT structure.</td></tr>
<tr> <td>16 </td> <td>bCharSet</td> <td>1</td> <td>Character set, as defined by the Windows API LOGFONT structure.</td></tr>
<tr> <td>17 </td> <td>(Reserved)</td> <td>1</td> <td>Reserved; must be 0 (zero).</td></tr>
<tr> <td>18 </td> <td>cch</td> <td>1</td> <td>Length of the font name.</td></tr>
<tr> <td>19 </td> <td>rgch</td> <td>var</td> <td>Font name.</td></tr>
</table>

<table>
<tr><th>FOOTER</th><th>Print Footer on Each Page </th><th>15</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>1</td> <td>Length of the footer string (bytes)</td></tr>
<tr> <td>5 </td> <td>rgch</td> <td>var</td> <td>Footer string</td></tr>
</table>

<table>
<tr><th>FORCEFULLCALCULATION</th><th>Force Full Calculation Mode </th><th>8A3</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08A3h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>fNoDeps</td> <td>4</td> <td>=1 if the workbook is in the forced calculation mode, in which case dependencies are ignored, and all worksheets are marked to calculate fully every time the calculation is triggered. Stored as 4-byte integer value</td></tr>
</table>

<table>
<tr><th>FORMAT</th><th>Number Format </th><th>41E</th></tr>
<tr> <td>4 </td> <td>ifmt</td> <td>2</td> <td>Format index code (for internal use only)</td></tr>
<tr> <td>6 </td> <td>cch</td> <td>2</td> <td>Length of the string</td></tr>
<tr> <td>7 </td> <td>grbit</td> <td>1</td> <td>Option Flags (described in Unicode Strings in BIFF8 section)</td></tr>
<tr> <td>8 </td> <td>rgb</td> <td>var</td> <td>Array of string characters</td></tr>
</table>

<table>
<tr><th>FORMULA</th><th>Cell Formula </th><th>6</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to XF record</td></tr>
<tr> <td>10 </td> <td>num</td> <td>8</td> <td>Current value of the formula (see text)</td></tr>
<tr> <td>18 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>20 </td> <td>chn</td> <td>4</td> <td>(See text)</td></tr>
<tr> <td>24 </td> <td>cce</td> <td>2</td> <td>Length of the parsed expression</td></tr>
<tr> <td>26 </td> <td>rgce</td> <td>var</td> <td>Parsed expression</td></tr>
</table>

<table>
<tr><th>GCW</th><th>Global Column-Width Flags </th><th>AB</th></tr>
<tr> <td>4 </td> <td>cb</td> <td>2</td> <td>Number of bytes in the global column-width flags</td></tr>
<tr> <td>6 </td> <td>grbitGCW</td> <td>2</td> <td>Global column-width flags for columns A through P</td></tr>
<tr> <td>8 </td> <td>grbitGCW</td> <td>2</td> <td>Global column-width flags for columns Q through AF</td></tr>
<tr> <td>... </td> <td>...</td> <td>var</td> <td>...</td></tr>
<tr> <td>4+cb </td> <td>grbitGCW</td> <td>2</td> <td>Global column-width flags for columns IG through IV</td></tr>
</table>

<table>
<tr><th>GRIDSET</th><th>State Change of Gridlines Option </th><th>82</th></tr>
<tr> <td>4 </td> <td>fGridSet</td> <td>2</td> <td>=1 if the user has ever changed the setting of the Gridlines option</td></tr>
</table>

<table>
<tr><th>GUIDTYPELIB</th><th>VB Project TypeLib GUID </th><th>897</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0897h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>guid</td> <td>16</td> <td>TypeLib GUID corresponding to the compiled version of VB project. Stored as 16-byte (128-bit) number</td></tr>
</table>

<table>
<tr><th>GUTS</th><th>Size of Row and Column Gutters </th><th>80</th></tr>
<tr> <td>4 </td> <td>dxRwGut</td> <td>2</td> <td>Size of the row gutter that appears to the left of the rows</td></tr>
<tr> <td>6 </td> <td>dyColGut</td> <td>2</td> <td>Size of the column gutter that appears above the columns</td></tr>
<tr> <td>8 </td> <td>iLevelRwMac</td> <td>2</td> <td>Maximum outline level (for the row gutter)</td></tr>
<tr> <td>10 </td> <td>iLevelColMac</td> <td>2</td> <td>Maximum outline level (for the column gutter)</td></tr>
</table>

<table>
<tr><th>HCENTER</th><th>Center Between Horizontal Margins </th><th>83</th></tr>
<tr> <td>4 </td> <td>fHCenter</td> <td>2</td> <td>=1 if the sheet is to be centered between horizontal margins when printed</td></tr>
</table>

<table>
<tr><th>HEADER</th><th>Print Header on Each Page </th><th>14</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>1</td> <td>Length of the header string (bytes)</td></tr>
<tr> <td>5 </td> <td>rgch</td> <td>var</td> <td>Header string</td></tr>
</table>

<table>
<tr><th>HEADERFOOTER</th><th>Header Footer </th><th>89C</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =089Ch</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>guidSview</td> <td>16</td> <td>If this header FRT belongs to a specific sheet view (sview), the sheet views GUID will be saved here.</td></tr>
<tr> <td>32 </td> <td>grbitFlags</td> <td>2</td> <td>see text</td></tr>
<tr> <td>34 </td> <td>cchHeaderEven</td> <td>2</td> <td>length of even header text</td></tr>
<tr> <td>36 </td> <td>cchFooterEven</td> <td>2</td> <td>length of even footer text</td></tr>
<tr> <td>38 </td> <td>cchHeaderFirst</td> <td>2</td> <td>length of first page header text</td></tr>
<tr> <td>40 </td> <td>cchFooterFirst</td> <td>2</td> <td>length of first page footer text</td></tr>
<tr> <td>42 </td> <td>rgchHeaderEven</td> <td>var</td> <td>even header text if non-zero length</td></tr>
<tr> <td>var </td> <td>rgchFooterEven</td> <td>var</td> <td>even footer text if non-zero length</td></tr>
<tr> <td>var </td> <td>rgchHeaderFirst</td> <td>var</td> <td>first page header text if non-zero length</td></tr>
<tr> <td>var </td> <td>rgchFooterFirst</td> <td>var</td> <td>first page footer text if non-zero length</td></tr>
</table>

<table>
<tr><th>HFPicture</th><th>Header / Footer Picture </th><th>866</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0866h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Must be zero</td></tr>
<tr> <td>16 </td> <td>rgf</td> <td>1</td> <td>Bit flags, see description below.</td></tr>
<tr> <td>15 </td> <td>rgb</td> <td>var</td> <td>An embedded encoding of the contents of the picture; May be in MSODRAWING or MSODRAWINGGROUP record format as indicated in rgf flags listed below.</td></tr>
</table>

<table>
<tr><th>HIDEOBJ</th><th>Object Display Options </th><th>8D</th></tr>
<tr> <td>4 </td> <td>fHideObj</td> <td>2</td> <td>=2 if the Hide All option is turned on =1 if the Show Placeholders option is turned on =0 if the Show All option is turned on</td></tr>
</table>

<table>
<tr><th>HLINK</th><th>Hyperlink </th><th>1B8</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row of the hyperlink</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row of the hyperlink</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>2</td> <td>First column of the hyperlink</td></tr>
<tr> <td>10 </td> <td>colLast</td> <td>2</td> <td>Last column of the hyperlink</td></tr>
<tr> <td>12 </td> <td>rgbHlink</td> <td>var</td> <td>Hyperlink stream (from the Microsoft Office DLL; this stream is not documented)</td></tr>
</table>

<table>
<tr><th>HLINKTOOLTIP</th><th>Hyperlink Tooltip </th><th>800</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0800h</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Information</td></tr>
<tr> <td>16 </td> <td>rgb</td> <td>var</td> <td>The hyperlink tooltip; a null-terminated unicode string</td></tr>
</table>

<table>
<tr><th>HORIZONTALPAGEBREAKS</th><th>Explicit Row Page Breaks </th><th>1B</th></tr>
<tr> <td>4 </td> <td>cbrk</td> <td>2</td> <td>Number of page breaks</td></tr>
<tr> <td>6 </td> <td>rgbrk</td> <td>var</td> <td>Array of brk structures</td></tr>
</table>

<table>
<tr><th>IMDATA</th><th>Image Data </th><th>7F</th></tr>
<tr> <td>4 </td> <td>cf</td> <td>2</td> <td>Image format: =02h, Windows metafile or Macintosh PICT format =09h, Windows bitmap format =0Eh, Native format (see text)</td></tr>
<tr> <td>6 </td> <td>env</td> <td>2</td> <td>Environment from which the file was written: =1, Microsoft Windows =2, Apple Macintosh</td></tr>
<tr> <td>8 </td> <td>lcb</td> <td>4</td> <td>Length of the image data</td></tr>
<tr> <td>12 </td> <td>data</td> <td>var</td> <td>Image data</td></tr>
</table>

<table>
<tr><th>INDEX</th><th>Index Record </th><th>20B</th></tr>
<tr> <td>4 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be 0 (zero)</td></tr>
<tr> <td>8 </td> <td>rwMic</td> <td>4</td> <td>First row that exists on the sheet</td></tr>
<tr> <td>12 </td> <td>rwMac</td> <td>4</td> <td>Last row that exists on the sheet, plus 1</td></tr>
<tr> <td>16 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be 0 (zero)</td></tr>
<tr> <td>20 </td> <td>rgibRw</td> <td>var</td> <td>Array of file offsets to the DBCELL records for each block of ROW records. A block contains ROW records for up to 32 rows. For more information, see Finding Cell Records in BIFF Files .</td></tr>
</table>

<table>
<tr><th>INTERFACEEND</th><th>End of User Interface Records </th><th>E2</th></tr>
</table>

<table>
<tr><th>INTERFACEHDR</th><th>Beginning of User Interface Records </th><th>E1</th></tr>
<tr> <td>4 </td> <td>Cv</td> <td>2</td> <td>Code page the file is saved in: 01B5h (437 dec.) = IBM PC (Multiplan) 8000h (32768 dec.) = Apple Macintosh 04E4h (1252 dec.) = ANSI (Microsoft Windows)</td></tr>
</table>

<table>
<tr><th>ITERATION</th><th>Iteration Mode </th><th>11</th></tr>
<tr> <td>4 </td> <td>fIter</td> <td>2</td> <td>=1 if the Iteration option is on</td></tr>
</table>

<table>
<tr><th>LBL</th><th>Specifies a defined name </th><th>18</th></tr>
<tr> <td>4 </td> <td>flgs</td> <td>2</td> <td>name flags</td></tr>
<tr> <td>6 </td> <td>chKey</td> <td>1</td> <td>macro shortcut key</td></tr>
<tr> <td>7 </td> <td>cch</td> <td>1</td> <td>name length</td></tr>
<tr> <td>8 </td> <td>cce</td> <td>2</td> <td>formula length</td></tr>
<tr> <td>10 </td> <td>res1</td> <td>2</td> <td>reserved</td></tr>
<tr> <td>12 </td> <td>itab</td> <td>2</td> <td>sheet loc index</td></tr>
<tr> <td>14 </td> <td>res2</td> <td>2</td> <td>reserved</td></tr>
<tr> <td>16 </td> <td>res3</td> <td>2</td> <td>reserved</td></tr>
<tr> <td>18 </td> <td>name</td> <td>var</td> <td>Array of string characters</td></tr>
<tr> <td>19 </td> <td>rgce</td> <td>var</td> <td>formula</td></tr>
</table>

<table>
<tr><th>LABEL</th><th>Cell Value, String Constant </th><th>204</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row (0-based)</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column (0-based)</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
<tr> <td>10 </td> <td>cch</td> <td>2</td> <td>Length of the string (must be <= 255)</td></tr>
<tr> <td>12 </td> <td>grbit</td> <td>1</td> <td>Option flags</td></tr>
<tr> <td>13 </td> <td>rgb</td> <td>var</td> <td>Array of string characters</td></tr>
</table>

<table>
<tr><th>LABELSST</th><th>Cell Value, String Constant/SST </th><th>FD</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row (0-based)</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column (0-based)</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
<tr> <td>10 </td> <td>isst</td> <td>4</td> <td>Index into the SST record where actual string is stored</td></tr>
</table>

<table>
<tr><th>LEFTMARGIN</th><th>Left Margin Measurement </th><th>26</th></tr>
<tr> <td>4 </td> <td>num</td> <td>8</td> <td>Left margin</td></tr>
</table>

<table>
<tr><th>LHNGRAPH</th><th>Named Graph Information </th><th>95</th></tr>
</table>

<table>
<tr><th>LIST12</th><th>Extra Table Data Introduced in Excel 2007 </th><th>877</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0877h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>lsd</td> <td>2</td> <td>Type of Table data contained in this record (see below for details)</td></tr>
<tr> <td>18 </td> <td>idList</td> <td>4</td> <td>Table unique ID</td></tr>
<tr> <td>22 </td> <td>rgb</td> <td>var</td> <td>Data of the record (see below for details)</td></tr>
</table>

<table>
<tr><th>LISTCF</th><th>List Cell Formatting </th><th>8c5</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c5h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description.</td></tr>
<tr> <td>16 </td> <td>rtcf</td> <td>var</td> <td>CF structure;</td></tr>
</table>

<table>
<tr><th>LISTCONDFMT</th><th>List Conditional Formatting </th><th>8c4</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c4h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description.</td></tr>
<tr> <td>16 </td> <td>rtcondfmt</td> <td>var</td> <td>CONDFMT structure;</td></tr>
</table>

<table>
<tr><th>LISTDV</th><th>List Data Validation </th><th>8c3</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c3h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description.</td></tr>
<tr> <td>16 </td> <td>rtdv</td> <td>var</td> <td>DV structure;</td></tr>
</table>

<table>
<tr><th>LISTFIELD</th><th>List Field </th><th>8c2</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c2h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description. Contains a REF that can be adjusted by a non-list-aware version of Excel</td></tr>
<tr> <td>16 </td> <td>wFileFlags</td> <td>2</td> <td>Flags</td></tr>
<tr> <td>18 </td> <td>ref</td> <td>8</td> <td>REF structure; location of field on sheet as known by list-aware version of Excel</td></tr>
<tr> <td>26 </td> <td>rwCount</td> <td>4</td> <td>Rw to calc against (offset from frtheader.ref.ewFirst) or max count</td></tr>
<tr> <td>30 </td> <td>wFieldFlags</td> <td>2</td> <td></td></tr>
<tr> <td>32 </td> <td>cchName</td> <td>2</td> <td></td></tr>
<tr> <td>38 </td> <td>cchFmla</td> <td>2</td> <td></td></tr>
</table>

<table>
<tr><th>LISTOBJ</th><th>List Object </th><th>8c1</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c1h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description. Contains a REF that can be adjusted by a non-list-aware version of Excel</td></tr>
<tr> <td>16 </td> <td>cFields</td> <td>2</td> <td></td></tr>
<tr> <td>18 </td> <td>cRecords</td> <td>2</td> <td></td></tr>
<tr> <td>20 </td> <td>ref</td> <td>8</td> <td>REF structure; location of field on sheet as known by a list-aware version of Excel</td></tr>
<tr> <td>28 </td> <td>wListFlags1</td> <td>2</td> <td></td></tr>
<tr> <td>30 </td> <td>wListFlags2</td> <td>2</td> <td></td></tr>
<tr> <td>32 </td> <td>Rgsortflags</td> <td>6</td> <td></td></tr>
<tr> <td>38 </td> <td>cchName</td> <td>2</td> <td>Size of rgbName</td></tr>
<tr> <td>40 </td> <td>rgbName</td> <td>var</td> <td>The name of the list.</td></tr>
</table>

<table>
<tr><th>LNEXT</th><th>Extension information for borders in Mac Office 11 </th><th>8c9</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c9h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>padding</td> <td>8</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>cvRGB</td> <td>4</td> <td>Line color in RGB format</td></tr>
<tr> <td>20 </td> <td>lOpacity</td> <td>4</td> <td>Line opacity (from 0 to 65,536)</td></tr>
</table>

<table>
<tr><th>LPR</th><th>Sheet Was Printed Using LINE.PRINT </th><th>98</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>cchMargLeft</td> <td>2</td> <td>Left margin, expressed as a count of characters</td></tr>
<tr> <td>8 </td> <td>cchMargRight</td> <td>2</td> <td>Right margin, expressed as a count of characters</td></tr>
<tr> <td>10 </td> <td>cliMargTop</td> <td>2</td> <td>Top margin, expressed as a count of lines</td></tr>
<tr> <td>12 </td> <td>cliMargBot</td> <td>2</td> <td>Bottom margin, expressed as a count of lines</td></tr>
<tr> <td>14 </td> <td>cliPg</td> <td>2</td> <td>Number of lines per page</td></tr>
<tr> <td>16 </td> <td>cch</td> <td>1</td> <td>Length of the printer setup string</td></tr>
<tr> <td>17 </td> <td>rgch</td> <td>var</td> <td>Printer setup string</td></tr>
</table>

<table>
<tr><th>MDTB</th><th>Block of Metadata Records </th><th>88A</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>rgmdir</td> <td>var</td> <td>Block of metadata records</td></tr>
</table>

<table>
<tr><th>MDTINFO</th><th>Information about a Metadata Type </th><th>884</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0884h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbit</td> <td>4</td> <td>Metadata type flags</td></tr>
<tr> <td>20 </td> <td>stName</td> <td>var</td> <td>Metadata type name; string</td></tr>
</table>

<table>
<tr><th>MDXKPI</th><th>Key Performance Indicator Mdx Metadata </th><th>889</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0889h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
</table>

<table>
<tr><th>MDXPROP</th><th>Member Property Mdx Metadata </th><th>888</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0888h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>istrConnName</td> <td>4</td> <td>Index of connection name in string store</td></tr>
<tr> <td>20 </td> <td>tfnSrc</td> <td>1</td> <td>Tag of the Cube function producing mdx metadata</td></tr>
<tr> <td>21 </td> <td>istrMbr</td> <td>4</td> <td>Index of member unique name in string store</td></tr>
<tr> <td>25 </td> <td>istrProp</td> <td>4</td> <td>Index of property name in string store</td></tr>
</table>

<table>
<tr><th>MDXSET</th><th>Set Mdx Metadata </th><th>887</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0887h</td></tr>
</table>

<table>
<tr><th>MDXSTR</th><th>MDX metadata string </th><th>885</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0885h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>St</td> <td>var</td> <td>Mdx metadata string; string</td></tr>
</table>

<table>
<tr><th>MDXTUPLE</th><th>Tuple Mdx Metadata </th><th>886</th></tr>
<tr> <td>4 </td> <td>Rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0886h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
</table>

<table>
<tr><th>MERGECELLS</th><th>Merged Cells </th><th>E5</th></tr>
<tr> <td>4 </td> <td>cmcs</td> <td>2</td> <td>Count of REF structures</td></tr>
<tr> <td>6 </td> <td>rgRef</td> <td>var</td> <td>Array of REF structures</td></tr>
</table>

<table>
<tr><th>MKREXT</th><th>Extension information for markers in Mac Office 11 </th><th>8ca</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08CAh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>padding</td> <td>8</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>cvRGBFore</td> <td>4</td> <td>Marker foreground color in RGB format</td></tr>
<tr> <td>20 </td> <td>cvRGBBack</td> <td>4</td> <td>Marker background color in RGB format</td></tr>
<tr> <td>24 </td> <td>lOpacity</td> <td>4</td> <td>Marker opacity (from 0 to 65,536)</td></tr>
</table>

<table>
<tr><th>MMS</th><th>ADDMENU/DELMENU Record Group Count </th><th>C1</th></tr>
<tr> <td>4 </td> <td>caitm</td> <td>1</td> <td>Number of ADDMENU record groups</td></tr>
<tr> <td>5 </td> <td>cditm</td> <td>1</td> <td>Number of DELMENU record groups</td></tr>
</table>

<table>
<tr><th>MSODRAWING</th><th>Microsoft Office Drawing </th><th>EC</th></tr>
<tr> <td>4 </td> <td>rgMSODrawing</td> <td>var</td> <td>Microsoft Office Drawing data</td></tr>
</table>

<table>
<tr><th>MSODRAWINGGROUP</th><th>Microsoft Office Drawing Group </th><th>EB</th></tr>
<tr> <td>4 </td> <td>rgMSODrawiGr</td> <td>var</td> <td>Microsoft Office Drawing group data</td></tr>
</table>

<table>
<tr><th>MSODRAWINGSELECTION</th><th>Microsoft Office Drawing Selection </th><th>ED</th></tr>
<tr> <td>4 </td> <td>rgMSODrSelr</td> <td>var</td> <td>Microsoft Office Drawing selection data</td></tr>
</table>

<table>
<tr><th>MTRSETTINGS</th><th>Multi-threaded Calculation Settings </th><th>89A</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =089Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>fMTREnabled</td> <td>4</td> <td>=1 if multi-threaded calculation is enabled; stored as 4-byte integer value</td></tr>
<tr> <td>20 </td> <td>fUserSetThreadCount</td> <td>4</td> <td>=1 if the thread count was manually specified by the user; stored as 4-byte integer value</td></tr>
<tr> <td>24 </td> <td>cUserThreadCount</td> <td>4</td> <td>The count of calc threads as specified by the user; stored as 4-byte integer value</td></tr>
</table>

<table>
<tr><th>MULBLANK</th><th>Multiple Blank Cells </th><th>BE</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row number (0-based)</td></tr>
<tr> <td>6 </td> <td>colFirst</td> <td>2</td> <td>Column number (0-based) of the first column of the multiple RK record</td></tr>
<tr> <td>8 </td> <td>rgixfe</td> <td>var</td> <td>Array of indexes to XF records</td></tr>
<tr> <td>10 </td> <td>colLast</td> <td>2</td> <td>Last column containing the BLANKREC structure</td></tr>
</table>

<table>
<tr><th>MULRK</th><th>Multiple RK Cells </th><th>BD</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row number (0-based)</td></tr>
<tr> <td>6 </td> <td>colFirst</td> <td>2</td> <td>Column number (0-based) of the first column of the multiple RK record</td></tr>
<tr> <td>8 </td> <td>rgrkrec</td> <td>var</td> <td>Array of 6-byte RKREC structures</td></tr>
<tr> <td>var </td> <td>colLast</td> <td>2</td> <td>Last column containing the RKREC structure</td></tr>
</table>

<table>
<tr><th>NAME</th><th>Defined Name </th><th>218</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>chKey</td> <td>1</td> <td>Keyboard shortcut</td></tr>
<tr> <td>7 </td> <td>cch</td> <td>1</td> <td>Length of the name text (in characters)</td></tr>
<tr> <td>8 </td> <td>cce</td> <td>2</td> <td>Length of the name definition</td></tr>
<tr> <td>10 </td> <td>ixals</td> <td>2</td> <td>Index to the sheet that contains this name, if the name is a local name (see text)</td></tr>
<tr> <td>12 </td> <td>itab</td> <td>2</td> <td>1-based index into the sheets in the current book, where the list is arranged by the visible order of the tabs.</td></tr>
<tr> <td>14 </td> <td>cchCustMenu</td> <td>1</td> <td>Length of the custom menu text</td></tr>
<tr> <td>15 </td> <td>cchDescription</td> <td>1</td> <td>Length of the description text</td></tr>
<tr> <td>16 </td> <td>cchHelptopic</td> <td>1</td> <td>Length of the help topic text</td></tr>
<tr> <td>17 </td> <td>cchStatustext</td> <td>1</td> <td>Length of the status bar text</td></tr>
<tr> <td>18 </td> <td>rgch</td> <td>var</td> <td>Name text (grbit/rgb fields as defined in Unicode Strings in BIFF8 .)</td></tr>
<tr> <td>var </td> <td>rgce</td> <td>var</td> <td>Name definition (see text)</td></tr>
<tr> <td>var </td> <td>rgchCustMenu</td> <td>var</td> <td>Custom menu text</td></tr>
<tr> <td>var </td> <td>rgchDescr</td> <td>var</td> <td>Description text</td></tr>
<tr> <td>var </td> <td>rgchHelptopic</td> <td>var</td> <td>Help topic text</td></tr>
<tr> <td>var </td> <td>rgchStatustext</td> <td>var</td> <td>Status bar text</td></tr>
</table>

<table>
<tr><th>NAMECMT</th><th>Name Comment </th><th>894</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0894h</td></tr>
</table>

<table>
<tr><th>NAMEFNGRP12</th><th>Extra Function Group </th><th>899</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0899h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>cachName</td> <td>2</td> <td>Number of characters in the name; 2-byte unsigned integer value</td></tr>
<tr> <td>18 </td> <td>fgrp</td> <td>2</td> <td>Number of the function group; 2-byte unsigned integer value</td></tr>
<tr> <td>20 </td> <td>rgach</td> <td>var</td> <td>ASCII name string of length cachName</td></tr>
</table>

<table>
<tr><th>NAMEPUBLISH</th><th>Publish to Excel Server Data for Name </th><th>893</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0893h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitPublishFlags</td> <td>2</td> <td>Publish data flags (see below for details)</td></tr>
<tr> <td>18 </td> <td>cachName</td> <td>2</td> <td>Number of characters in the name</td></tr>
<tr> <td>20 </td> <td>rgach</td> <td>var</td> <td>ASCII name string of length cachName</td></tr>
</table>

<table>
<tr><th>NOTE</th><th>Comment Associated with a Cell </th><th>1C</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row of the comment</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column of the comment</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>Options flag (see table below)</td></tr>
<tr> <td>10 </td> <td>idObj</td> <td>2</td> <td>Object id for OBJ record that contains the comment</td></tr>
<tr> <td>12 </td> <td>stAuthor</td> <td>var</td> <td>Name of the original comment author (as Unicode string )</td></tr>
</table>

<table>
<tr><th>NUMBER</th><th>Cell Value, Floating-Point Number </th><th>203</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
<tr> <td>10 </td> <td>num</td> <td>8</td> <td>Floating-point number value</td></tr>
</table>

<table>
<tr><th>OBJPROTECT</th><th>Objects Are Protected </th><th>63</th></tr>
<tr> <td>4 </td> <td>fLockObj</td> <td>2</td> <td>=1 if objects are protected</td></tr>
</table>

<table>
<tr><th>OBPROJ</th><th>Visual Basic Project </th><th>D3</th></tr>
<tr> <td>4 </td> <td>(Reserved)</td> <td>var</td> <td></td></tr>
</table>

<table>
<tr><th>OLEDBCONN</th><th>OLE Database Connection </th><th>80A</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbitConn</td> <td>2</td> <td>Connection flags; see following table</td></tr>
<tr> <td>10 </td> <td>cst</td> <td>2</td> <td>Count of following ExtString records; these records will be concatenated together to make the connection string</td></tr>
<tr> <td>12 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>rgbFuture</td> <td>var</td> <td>Information from future versions of Excel</td></tr>
</table>

<table>
<tr><th>OLESIZE</th><th>Size of OLE Object </th><th>DE</th></tr>
<tr> <td>4 </td> <td>(Reserved)</td> <td>2</td> <td></td></tr>
<tr> <td>6 </td> <td>rwFirst</td> <td>2</td> <td>First row</td></tr>
<tr> <td>8 </td> <td>rwLast</td> <td>2</td> <td>Last row</td></tr>
<tr> <td>10 </td> <td>colFirst</td> <td>1</td> <td>First column</td></tr>
<tr> <td>11 </td> <td>colLast</td> <td>1</td> <td>Last column</td></tr>
</table>

<table>
<tr><th>PALETTE</th><th>Color Palette Definition </th><th>92</th></tr>
<tr> <td>4 </td> <td>ccv</td> <td>2</td> <td>Count of color values that follow</td></tr>
<tr> <td>6 </td> <td>rgch</td> <td>4</td> <td>Color value of the first color in the palette</td></tr>
<tr> <td>10 </td> <td>rgch</td> <td>4</td> <td>Color value of the second color in the palette</td></tr>
<tr> <td>14 </td> <td>rgch</td> <td>4</td> <td>Color value of the third color in the palette</td></tr>
<tr> <td>18 </td> <td>colors</td> <td>var</td> <td>all the colors from count</td></tr>
<tr> <td>var </td> <td>rgch</td> <td>4</td> <td>Color value of the last color (=ccv) in the palette</td></tr>
</table>

<table>
<tr><th>PANE</th><th>Number of Panes and Their Position </th><th>41</th></tr>
<tr> <td>4 </td> <td>x</td> <td>2</td> <td>Horizontal position of the split; 0 (zero) if none</td></tr>
<tr> <td>6 </td> <td>y</td> <td>2</td> <td>Vertical position of the split; 0 (zero) if none</td></tr>
<tr> <td>8 </td> <td>rwTop</td> <td>2</td> <td>Top row visible in the bottom pane</td></tr>
<tr> <td>10 </td> <td>colLeft</td> <td>2</td> <td>Leftmost column visible in the right pane</td></tr>
<tr> <td>12 </td> <td>pnnAct</td> <td>2</td> <td>Pane number of the active pane</td></tr>
</table>

<table>
<tr><th>PARAMQRY</th><th>Query Parameters </th><th>DC</th></tr>
<tr> <td>4 </td> <td>wTypeSql</td> <td>2</td> <td>Used for ODBC queries; the parameter SQL type</td></tr>
<tr> <td>6 </td> <td>flags</td> <td>2</td> <td>Option flags; see following table</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>If pbt=1 then this value indicates what type of value is in rgb: 0001h = an IEEE number 0002h = a variable-length Unicode string 0004h = a Boolean but the value is stored in fVal rather than rgb 0800h = an integer</td></tr>
<tr> <td>10 </td> <td>fVal</td> <td>2</td> <td>A true/false value if pbt=2 and the parameter is a Boolean</td></tr>
<tr> <td>12 </td> <td>rgb</td> <td>var</td> <td>if pbt=0, prompt string as a Unicode string if pbt=1, refer to grbit if pbt=2, reference as parsed expression</td></tr>
</table>

<table>
<tr><th>PASSWORD</th><th>Protection Password </th><th>13</th></tr>
<tr> <td>4 </td> <td>wPassword</td> <td>2</td> <td>Encrypted password</td></tr>
</table>

<table>
<tr><th>PLS</th><th>Environment-Specific Print Record </th><th>4D</th></tr>
<tr> <td>4 </td> <td>wEnv</td> <td>2</td> <td>Operating environment: 0= Microsoft Windows 1= Apple Macintosh</td></tr>
<tr> <td>6 </td> <td>rgb</td> <td>var</td> <td>TPrint structure (for more information about this structure, see Inside Macintosh, Volume II, page 149).</td></tr>
</table>

<table>
<tr><th>PLV</th><th>Page Layout View in Mac Excel 11 </th><th>8c8</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =08c5h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbitFlags</td> <td>1</td> <td>Flags</td></tr>
<tr> <td>9 </td> <td>wscale</td> <td>4</td> <td></td></tr>
</table>

<table>
<tr><th>PLV</th><th>Page Layout View Settings in Excel 2007 </th><th>88B</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Bh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>wScalePLV</td> <td>2</td> <td>Zoom scale for the worksheet, =100 if zoom is 100%; 2-byte unsigned integer value</td></tr>
<tr> <td>18 </td> <td>grbit</td> <td>2</td> <td>Page layout view flags (see below for details)</td></tr>
</table>

<table>
<tr><th>PRECISION</th><th>Precision </th><th>0E</th></tr>
<tr> <td>4 </td> <td>fFullPrec</td> <td>2</td> <td>=0 if Precision As Displayed option is selected</td></tr>
</table>

<table>
<tr><th>PRINTGRIDLINES</th><th>Print Gridlines Flag </th><th>2B</th></tr>
<tr> <td>4 </td> <td>fPrintGrid</td> <td>2</td> <td>=1 to print gridlines</td></tr>
</table>

<table>
<tr><th>PRINTHEADERS</th><th>Print Row/Column Labels </th><th>2A</th></tr>
<tr> <td>4 </td> <td>fPrintRwCol</td> <td>2</td> <td>=1 to print row and column headings</td></tr>
</table>

<table>
<tr><th>PROTECT</th><th>Protection Flag </th><th>12</th></tr>
<tr> <td>4 </td> <td>fLock</td> <td>2</td> <td>=1 if the sheet or workbook is protected</td></tr>
</table>

<table>
<tr><th>PROT4REV</th><th>Shared Workbook Protection Flag </th><th>1AF</th></tr>
<tr> <td>4 </td> <td>fRevLock</td> <td>2</td> <td>=1 if the Sharing with Track Changes option is on (Protect Shared Workbook dialog box)</td></tr>
</table>

<table>
<tr><th>PROT4REVPASS</th><th>Shared Workbook Protection Password </th><th>1BC</th></tr>
<tr> <td>4 </td> <td>wRevPass</td> <td>2</td> <td>Encrypted password (if this field is 0 (zero), there is no Shared Workbook Protection Password; the password is entered in the Protect Shared Workbook dialog box)</td></tr>
</table>

<table>
<tr><th>PUB</th><th>Publisher </th><th>89</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>ref</td> <td>6</td> <td>Reference structure describing the published area on the worksheet</td></tr>
<tr> <td>12 </td> <td>sec</td> <td>36</td> <td>Section record associated with the published area</td></tr>
<tr> <td>48 </td> <td>rgbAlias</td> <td>var</td> <td>Contents of the alias pointed to by the section record</td></tr>
</table>

<table>
<tr><th>QSI</th><th>External Data Range </th><th>1AD</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags; see following table.</td></tr>
<tr> <td>6 </td> <td>itblAutoFmt</td> <td>2</td> <td>Index to autoformat table.</td></tr>
<tr> <td>8 </td> <td>grbitAtrAutoFmt</td> <td>2</td> <td>Low-order 6 bits contain autoformat attribute flag bits; the high-order 10 bits are reserved.</td></tr>
<tr> <td>10 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be 0 (zero).</td></tr>
<tr> <td>14 </td> <td>cchName</td> <td>1</td> <td>Length of name.</td></tr>
</table>

<table>
<tr><th>QSIF</th><th>Query Table Field Formatting </th><th>807</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0807h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>4</td> <td>Union of flags; see table</td></tr>
<tr> <td>12 </td> <td>idField</td> <td>4</td> <td>ID number of the query table field; this is a unique identification tag</td></tr>
</table>

<table>
<tr><th>QSIR</th><th>Query Table Formatting </th><th>806</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0806h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; bitfFrtRef must be set to 1; see FRT Record Description</td></tr>
<tr> <td>8 </td> <td>REF</td> <td>8</td> <td>REF structure; see FRT Record Description</td></tr>
<tr> <td>16 </td> <td>cbQsirSaved</td> <td>2</td> <td>Number of bytes in the QSIR structure as saved (starting with the grbit field and ending with the rgbEx field, inclusive)</td></tr>
<tr> <td>18 </td> <td>cbQsifSaved</td> <td>2</td> <td>Number of bytes in each QSIF structure as saved (starting with the grbit field and ending with the rgbEx field, inclusive)</td></tr>
<tr> <td>20 </td> <td>grbit</td> <td>4</td> <td>Query table flags; see table</td></tr>
<tr> <td>24 </td> <td>iSortCustom</td> <td>4</td> <td>ID of custom sort order applied</td></tr>
<tr> <td>28 </td> <td>cQsif</td> <td>4</td> <td>Count of QSIF structures; these records immediately follow the QSIR record</td></tr>
<tr> <td>32 </td> <td>cpstDeleted</td> <td>4</td> <td>Count of strings; these are the columns that are in the database query but have been removed from the query table; stored in the rgbTitle array, below</td></tr>
<tr> <td>36 </td> <td>idFieldNext</td> <td>4</td> <td>First ID number available for assignment to a newly-created QSIF structure</td></tr>
<tr> <td>40 </td> <td>ccolExtraLeft</td> <td>2</td> <td>Columns to the left of the Query Table that are to be sorted with the Query Table</td></tr>
<tr> <td>42 </td> <td>ccolExtraRight</td> <td>2</td> <td>Columns to the right of the Query Table that are to be sorted with the Query Table</td></tr>
<tr> <td>44 </td> <td>idList</td> <td>4</td> <td>XL11: Table ID if linked to a Table</td></tr>
<tr> <td>48 </td> <td>rgbEx</td> <td>var</td> <td>Bytes reserved for extra information to be written by future versions of Excel; the size of this field is determined by cbQsirSaved</td></tr>
<tr> <td>var </td> <td>rgbTitle</td> <td>var</td> <td>Unicode strings; these are the names of the database fields that have been removed from the Query Table</td></tr>
</table>

<table>
<tr><th>QSISXTAG</th><th>Pivot Table and Query Table Extensions </th><th>802</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0802h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>fSx</td> <td>2</td> <td>=0 if the record is for a Query Table =1 if the record is for a Pivot Table</td></tr>
<tr> <td>10 </td> <td>grbit</td> <td>2</td> <td>General options; see following table</td></tr>
<tr> <td>12 </td> <td>dwQsiFuture</td> <td>4</td> <td>Feature-specific options; see following table</td></tr>
<tr> <td>16 </td> <td>VerSxLastUpdated</td> <td>1</td> <td>Version of Excel that last refreshed the Pivot Table only used in the Pivot Table case otherwise must be zero; =0 if Excel 2000 =1 if Excel XP =2 if Excel 2003 =3 if Office Excel 2007</td></tr>
<tr> <td>17 </td> <td>VerSxUpdateableMin</td> <td>1</td> <td>Version of Excel that last refreshed the Pivot Table (see values for VerSxLastUpdated) only used in the Pivot Table case otherwise must be zero</td></tr>
<tr> <td>18 </td> <td>obCchName</td> <td>1</td> <td>Offset in bytes from beginning of FRT to beginning of cchName</td></tr>
<tr> <td>19 </td> <td>bVerRtqsisxtag</td> <td>1</td> <td>Version of Excel that first created the PivotTable or Query Table</td></tr>
<tr> <td>20</td> <td>stName</td> <td>var</td> <td>name of pivot or query table</td></tr>
</table>

<table>
<tr><th>REALTIMEDATA</th><th>Real-Time Data </th><th>813</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0813h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>ichSamePrefix</td> <td>4</td> <td>Number of leading characters in common with the previous Topic string (implicitly understood, and not to be repeated in this record); basically the length of any common prefix between the Topic of this record and the Topic of the previous REALTIMEDATA record. Zero if there is no prefix in common, or if this is the first REALTIMEDATA record.</td></tr>
<tr> <td>12 </td> <td>cchTopic</td> <td>4</td> <td>Count of characters in the Topic string, not including the implicit prefix if ichSamePrefix is greater than zero.</td></tr>
<tr> <td>16 </td> <td>rgchTopic</td> <td>var</td> <td>Topic string, not including the implicit prefix, if any. May be encoded as a compressed or uncompressed Unicode string. (See section titled Unicode Strings in Biff8 for more information about these encodings.)</td></tr>
<tr> <td>var </td> <td>RTDOPER</td> <td>var</td> <td>RTDOPER contains variant type and data of RTD data (similar to but not identical to OPER structure used elsewhere)</td></tr>
<tr> <td>var </td> <td>rgRTDE</td> <td>var</td> <td>Variable-length array of RTDE structures, describing the set of cells associated with the RTD topic. Each RTDE contains row, column, and sheet tab index. Length of array determined by record size of this record and any CONTINUEFRT records.</td></tr>
</table>

<table>
<tr><th>RECALCID</th><th>Recalc Information </th><th>1C1</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type repeated; 1C1h</td></tr>
<tr> <td>6 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be zero</td></tr>
<tr> <td>8 </td> <td>dwBuild</td> <td>4</td> <td>Recalc engine ID</td></tr>
</table>

<table>
<tr><th>RECIPNAME</th><th>Recipient Name </th><th>B9</th></tr>
<tr> <td>4 </td> <td>cchRecip</td> <td>2</td> <td>Length of the recipients friendly name string</td></tr>
<tr> <td>6 </td> <td>ulEIDSize</td> <td>4</td> <td>Length of recipients system-specific address string</td></tr>
<tr> <td>10 </td> <td>rgchFriendly</td> <td>var</td> <td>recipients friendly name (null-terminated)</td></tr>
<tr> <td>var </td> <td>rgchSSAddr</td> <td>var</td> <td>recipients system-specific address (null-terminated)</td></tr>
</table>

<table>
<tr><th>REFMODE</th><th>Reference Mode </th><th>0F</th></tr>
<tr> <td>4 </td> <td>fRefA1</td> <td>2</td> <td>Reference mode: =1 for A1 mode =0 for R1C1 mode</td></tr>
</table>

<table>
<tr><th>REFRESHALL</th><th>Refresh Flag </th><th>1B7</th></tr>
<tr> <td>4 </td> <td>fRefreshAll</td> <td>2</td> <td>=1 then Refresh All should be done on all external data ranges and PivotTables when loading the workbook (the default is =0)</td></tr>
</table>

<table>
<tr><th>RIGHTMARGIN</th><th>Right Margin Measurement </th><th>27</th></tr>
<tr> <td>4 </td> <td>num</td> <td>8</td> <td>Right margin</td></tr>
</table>

<table>
<tr><th>RK2</th><th>Cell Value, RK Number </th><th>27E</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row number</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column number</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record that contains the cell format</td></tr>
<tr> <td>10 </td> <td>rk</td> <td>4</td> <td>RK number (see the following description)</td></tr>
</table>

<table>
<tr><th>RK</th><th>Cell Value, RK Number </th><th>7E</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row number</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column number</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record that contains the cell format</td></tr>
<tr> <td>10 </td> <td>rk</td> <td>4</td> <td>RK number (see the following description)</td></tr>
</table>

<table>
<tr><th>ROW</th><th>Describes a Row </th><th>208</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row number.</td></tr>
<tr> <td>6 </td> <td>colMic</td> <td>2</td> <td>First defined column in the row.</td></tr>
<tr> <td>8 </td> <td>colMac</td> <td>2</td> <td>Last defined column in the row, plus 1.</td></tr>
<tr> <td>10 </td> <td>miyRw</td> <td>2</td> <td>Row height.</td></tr>
<tr> <td>12 </td> <td>irwMac</td> <td>2</td> <td>Used by Excel to optimize loading the file; if you are creating a BIFF file, set irwMac to 0.</td></tr>
<tr> <td>14 </td> <td>(Reserved)</td> <td>2</td> <td></td></tr>
<tr> <td>16 </td> <td>grbit</td> <td>2</td> <td>Option flags.</td></tr>
<tr> <td>18 </td> <td>ixfe</td> <td>2</td> <td>If fGhostDirty=1 (see grbit field), this is the index to the XF record for the row. Otherwise, this field is undefined. Note: ixfe uses only the low-order 12 bits of the field (bits 110). Bit 12 is fExAsc, bit 13 is fExDsc, and bits 14 and 15 are reserved. fExAsc and fExDsc are set to true if the row has a thick border on top or on bottom, respectively.</td></tr>
</table>

<table>
<tr><th>RSTRING</th><th>Cell with Character Formatting </th><th>D6</th></tr>
<tr> <td>4 </td> <td>rw</td> <td>2</td> <td>Row</td></tr>
<tr> <td>6 </td> <td>col</td> <td>2</td> <td>Column</td></tr>
<tr> <td>8 </td> <td>ixfe</td> <td>2</td> <td>Index to the XF record</td></tr>
<tr> <td>10 </td> <td>cch</td> <td>2</td> <td>Length of the string</td></tr>
<tr> <td>12 </td> <td>rgch</td> <td>var</td> <td>String</td></tr>
<tr> <td>var </td> <td>cruns</td> <td>1</td> <td>Count of STRUN structures</td></tr>
<tr> <td>var </td> <td>rgstrun</td> <td>var</td> <td>Array of STRUN structures</td></tr>
</table>

<table>
<tr><th>SAVERECALC</th><th>Recalculate Before Save </th><th>5F</th></tr>
<tr> <td>4 </td> <td>fSaveRecalc</td> <td>2</td> <td>=1 to recalculate before saving</td></tr>
</table>

<table>
<tr><th>SCENARIO</th><th>Scenario Data </th><th>AF</th></tr>
<tr> <td>4 </td> <td>cref</td> <td>2</td> <td>Number of changing cells</td></tr>
<tr> <td>6 </td> <td>fLocked</td> <td>1</td> <td>=1 if the scenario is locked for changes</td></tr>
<tr> <td>7 </td> <td>fHidden</td> <td>1</td> <td>=1 if the scenario is hidden</td></tr>
<tr> <td>8 </td> <td>cchName</td> <td>1</td> <td>Length of the name</td></tr>
<tr> <td>9 </td> <td>cchComment</td> <td>1</td> <td>Length of the comment</td></tr>
<tr> <td>10 </td> <td>cchNameUser</td> <td>1</td> <td>Length of the user name</td></tr>
<tr> <td>11 </td> <td>rgchName</td> <td>var</td> <td>scenario name string (grbit/rgb fields only of unicode string )</td></tr>
<tr> <td></td> <td>rgchNameUser</td> <td>var</td> <td>user name full unicode string</td></tr>
<tr> <td></td> <td>rgchComment</td> <td>var</td> <td>comment full unicode string</td></tr>
<tr> <td>var </td> <td>rgRef</td> <td>var</td> <td>Array of cref cell references that contains changing cells (see text)</td></tr>
<tr> <td>var </td> <td>rgst</td> <td>var</td> <td>Array of cref byte-counted strings that contains changing cell values (see text)</td></tr>
<tr> <td>var </td> <td>rgIfmt</td> <td>var</td> <td>Array of cref ifmt integers (see text)</td></tr>
</table>

<table>
<tr><th>SCENMAN</th><th>Scenario Output Data </th><th>AE</th></tr>
<tr> <td>4 </td> <td>csct</td> <td>2</td> <td>Number of scenarios</td></tr>
<tr> <td>6 </td> <td>isctCur</td> <td>2</td> <td>Index of the current scenario</td></tr>
</table>

<table>
<tr><th>SCENPROTECT</th><th>Scenario Protection </th><th>DD</th></tr>
<tr> <td>4 </td> <td>fScenProtect</td> <td>2</td> <td>=1 if scenarios are protected</td></tr>
</table>

<table>
<tr><th>SCL</th><th>Window Zoom Magnification </th><th>A0</th></tr>
<tr> <td>4 </td> <td>nscl</td> <td>2</td> <td>Numerator of a reduced fraction</td></tr>
<tr> <td>6 </td> <td>dscl</td> <td>2</td> <td>Denominator of a reduced fraction</td></tr>
</table>

<table>
<tr><th>SELECTION</th><th>Current Selection </th><th>1D</th></tr>
<tr> <td>4 </td> <td>pnn</td> <td>1</td> <td>Number of the pane described</td></tr>
<tr> <td>5 </td> <td>rwAct</td> <td>2</td> <td>Row number of the active cell</td></tr>
<tr> <td>7 </td> <td>colAct</td> <td>2</td> <td>Column number of the active cell</td></tr>
<tr> <td>9 </td> <td>irefAct</td> <td>2</td> <td>ref number of the active cell</td></tr>
<tr> <td>11 </td> <td>cref</td> <td>2</td> <td>Number of refs in the selection</td></tr>
<tr> <td>13 </td> <td>rgref</td> <td>var</td> <td>Array of refs</td></tr>
</table>

<table>
<tr><th>SETUP</th><th>Page Setup </th><th>A1</th></tr>
<tr> <td>4 </td> <td>iPaperSize</td> <td>2</td> <td>Paper size (see fNoPls in the following table)</td></tr>
<tr> <td>6 </td> <td>iScale</td> <td>2</td> <td>Scaling factor (see fNoPls in the following table)</td></tr>
<tr> <td>8 </td> <td>iPageStart</td> <td>2</td> <td>Starting page number</td></tr>
<tr> <td>10 </td> <td>iFitWidth</td> <td>2</td> <td>Fit to width; number of pages</td></tr>
<tr> <td>12 </td> <td>iFitHeight</td> <td>2</td> <td>Fit to height; number of pages</td></tr>
<tr> <td>14 </td> <td>grbit</td> <td>2</td> <td>Option flags (see the following table)</td></tr>
<tr> <td>16 </td> <td>iRes</td> <td>2</td> <td>Print resolution (see fNoPls in the following table)</td></tr>
<tr> <td>18 </td> <td>iVRes</td> <td>2</td> <td>Vertical print resolution (see fNoPls in the following table)</td></tr>
<tr> <td>20 </td> <td>numHdr</td> <td>8</td> <td>Header margin (IEEE number)</td></tr>
<tr> <td>28 </td> <td>numFtr</td> <td>8</td> <td>Footer margin (IEEE number)</td></tr>
<tr> <td>36 </td> <td>iCopies</td> <td>2</td> <td>Number of copies (see fNoPls in the following table)</td></tr>
</table>

<table>
<tr><th>SHEETEXT</th><th>Extra Sheet Info </th><th>862</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0862h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(unused)</td> <td>8</td> <td>Reserved; must be zero</td></tr>
<tr> <td>16 </td> <td>cb</td> <td>4</td> <td>=14h (Record size minus 4); may be larger in the future</td></tr>
<tr> <td>20 </td> <td>rgbShxData</td> <td>4</td> <td>Colored tab info and reserved bits; may be larger in future; see the following description</td></tr>
</table>

<table>
<tr><th>SHRFMLA</th><th>Shared Formula </th><th>4BC</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>1</td> <td>First column</td></tr>
<tr> <td>9 </td> <td>colLast</td> <td>1</td> <td>Last column</td></tr>
<tr> <td>10 </td> <td>(Reserved)</td> <td>2</td> <td></td></tr>
<tr> <td>12 </td> <td>cce</td> <td>2</td> <td>Length of the parsed expression</td></tr>
<tr> <td>14 </td> <td>rgce</td> <td>var</td> <td>Parsed expression</td></tr>
</table>

<table>
<tr><th>SORT</th><th>Sorting Options </th><th>90</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>cchKey1</td> <td>1</td> <td>Length of the string for sort key 1</td></tr>
<tr> <td>7 </td> <td>cchKey2</td> <td>1</td> <td>Length of the string for sort key 2</td></tr>
<tr> <td>8 </td> <td>cchKey3</td> <td>1</td> <td>Length of the string for sort key 3</td></tr>
<tr> <td>9 </td> <td>rgchKey1</td> <td>var</td> <td>String for sort key 1</td></tr>
<tr> <td>var </td> <td>rgchKey2</td> <td>var</td> <td>String for sort key 2</td></tr>
<tr> <td>var </td> <td>rgchKey3</td> <td>var</td> <td>String for sort key 3</td></tr>
</table>

<table>
<tr><th>SORTDATA12</th><th>Sort Data 12 </th><th>895</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0895h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitSort</td> <td>2</td> <td>see text</td></tr>
<tr> <td>18 </td> <td>rwFirst</td> <td>4</td> <td>First row of cell range to sort</td></tr>
<tr> <td>22 </td> <td>rwLast</td> <td>4</td> <td>Last row of cell range to sort</td></tr>
<tr> <td>26 </td> <td>colFirst</td> <td>4</td> <td>First column of cell range to sort</td></tr>
<tr> <td>30 </td> <td>colLast</td> <td>4</td> <td>Last column of cell range to sort</td></tr>
<tr> <td>34 </td> <td>cconditions</td> <td>4</td> <td>count of sort conditions</td></tr>
<tr> <td>38 </td> <td>idParent</td> <td>8</td> <td>the parents ID if the sort field parent is a list object or a query table.</td></tr>
</table>

<table>
<tr><th>SOUND</th><th>Sound Note </th><th>96</th></tr>
<tr> <td>4 </td> <td>cf</td> <td>2</td> <td>Clipboard format; 4257h (16,983 decimal) for sound notes</td></tr>
<tr> <td>6 </td> <td>env</td> <td>2</td> <td>Environment from which the file was written: =1, Microsoft Windows =2, Apple Macintosh</td></tr>
<tr> <td>8 </td> <td>lcb</td> <td>4</td> <td>Length of the sound data</td></tr>
<tr> <td>12 </td> <td>data</td> <td>var</td> <td>Sound data</td></tr>
</table>

<table>
<tr><th>SST</th><th>Shared String Table </th><th>FC</th></tr>
<tr> <td>4 </td> <td>cstTotal</td> <td>4</td> <td>Total number of strings in the shared string table and extended string table (EXTSST record)</td></tr>
<tr> <td>8 </td> <td>cstUnique</td> <td>4</td> <td>Number of unique strings in the shared string table</td></tr>
<tr> <td>12 </td> <td>rgb</td> <td>var</td> <td>Array of unique unicode strings .</td></tr>
</table>

<table>
<tr><th>STANDARDWIDTH</th><th>Standard Column Width </th><th>99</th></tr>
<tr> <td>4 </td> <td>DxGCol</td> <td>2</td> <td>Standard column width, in increments of 1/256th of a character width</td></tr>
</table>

<table>
<tr><th>STRING</th><th>String Value of a Formula </th><th>207</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>2</td> <td>Length of the string</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>1</td> <td>0= Compressed unicode string 1= Uncompressed unicode string</td></tr>
<tr> <td>7 </td> <td>rgch</td> <td>var</td> <td>String</td></tr>
</table>

<table>
<tr><th>STYLE</th><th>Style Information </th><th>293</th></tr>
<tr> <td>4 </td> <td>ixfe</td> <td>2</td> <td>Index to the style XF record. Note: ixfe uses only the low-order 12 bits of the field (bits 110). Bits 12, 13, and 14 are unused, and bit 15 (fBuiltIn) is 1 for built-in styles.</td></tr>
<tr> <td>6 </td> <td>istyBuiltIn</td> <td>1</td> <td>Built-in style numbers: =00h Normal =01h RowLevel_n =02h ColLevel_n =03h Comma =04h Currency =05h Percent =06h Comma[0] =07h Currency[0]</td></tr>
<tr> <td>7 </td> <td>iLevel</td> <td>1</td> <td>Level of the outline style RowLevel_n or ColLevel_n (see text).</td></tr>
</table>

<table>
<tr><th>STYLEEXT</th><th>Named Cell Style Extension </th><th>892</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0892h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitFlags</td> <td>1</td> <td>see below</td></tr>
<tr> <td>17 </td> <td>iCategory</td> <td>1</td> <td>style category</td></tr>
<tr> <td>18 </td> <td>istyBuiltIn</td> <td>1</td> <td>style built in ID</td></tr>
</table>

<table>
<tr><th>SUB</th><th>Subscriber </th><th>91</th></tr>
<tr> <td>4 </td> <td>ref</td> <td>6</td> <td>Reference structure describing the subscribed area on the worksheet.</td></tr>
<tr> <td>10 </td> <td>drwReal</td> <td>2</td> <td>Actual number of rows in the subscribed area.</td></tr>
<tr> <td>12 </td> <td>dcolReal</td> <td>2</td> <td>Actual number of columns in the subscribed area.</td></tr>
<tr> <td>14 </td> <td>grbit</td> <td>2</td> <td>Option flags.</td></tr>
<tr> <td>16 </td> <td>cbAlias</td> <td>2</td> <td>Size of rgbAlias.</td></tr>
</table>

<table>
<tr><th>SUPBOOK</th><th>Supporting Workbook </th><th>1AE</th></tr>
<tr> <td>4 </td> <td>ctab</td> <td>2</td> <td>Number of tabs in the workbook</td></tr>
<tr> <td>6 </td> <td>stVirtPath</td> <td>var</td> <td>Encoded file name of the workbook as a unicode string (see text for file name encoding characters)</td></tr>
<tr> <td>var </td> <td>rgst</td> <td>var</td> <td>Array of ctab sheet tab names as unicode strings .</td></tr>
</table>

<table>
<tr><th>SXADDL</th><th>Pivot Table Additional Info </th><th>864</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0864h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>sxc</td> <td>1</td> <td>PivotTable, PivotCache or Query Table class of information contained in this record (View, Field, etc.); see description of sxc values below.</td></tr>
<tr> <td>9 </td> <td>sxd</td> <td>1</td> <td>PivotTable, PivotCache or Query Table data type contained in this record (Id, End, etc.); see description of sxd values below.</td></tr>
<tr> <td>10 </td> <td>dwUserData</td> <td>4</td> <td>Extra piece of data for this record. Usage is dependant on the sxc and sxd.</td></tr>
<tr> <td>14 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; Must be zero.</td></tr>
<tr> <td>16 </td> <td>rgbSxAddlData</td> <td>var</td> <td>Data for this record. Usage is dependant on the sxc and sxd.</td></tr>
</table>

<table>
<tr><th>SXADDL12</th><th>Additional Workbook Connections Information </th><th>881</th></tr>
</table>

<table>
<tr><th>SXDB</th><th>PivotTable Cache Data </th><th>C6</th></tr>
<tr> <td>4 </td> <td>crdbdb</td> <td>4</td> <td>Number of records in database</td></tr>
<tr> <td>8 </td> <td>idstm</td> <td>2</td> <td>Identifies the stream</td></tr>
<tr> <td>10 </td> <td>grbit</td> <td>2</td> <td>=01h, fSaveData data is saved with table layout. =02h, fInvalid the PivotTable must be refreshed before the next update. =04h, fRefreshOnLoad the PivotTable will be refreshed on load. =08h, fOptimizeCache the cache is optimized to use the least amount of memory. =10h, fBackgroundQuery results of the query are obtained in the background. =20h, fEnableRefresh refresh is enabled.</td></tr>
<tr> <td>12 </td> <td>crdbDbb</td> <td>2</td> <td>Number of records for each database block.</td></tr>
<tr> <td>14 </td> <td>cfdbdb</td> <td>2</td> <td>Number of base fields in databases.</td></tr>
<tr> <td>16 </td> <td>cfdbTot</td> <td>2</td> <td>Number of base fields, grouped fields, and calculated fields.</td></tr>
<tr> <td>18 </td> <td>crdbUsed</td> <td>2</td> <td>This value is not used and can be set to zero.</td></tr>
<tr> <td>20 </td> <td>vsType</td> <td>2</td> <td>Data source is one of: =1, Excel worksheet =2, External Data =4, Consolidation =8, Scenario PivotTable</td></tr>
<tr> <td>22 </td> <td>cchWho</td> <td>2</td> <td>Number of characters in the string containing the name of the user who last refreshed the PivotTable.</td></tr>
<tr> <td>24 </td> <td>rgb</td> <td>var</td> <td>String, represents the number of the user who last refreshed the PivotTable. Length is in cchWho.</td></tr>
</table>

<table>
<tr><th>SXDBEX</th><th>PivotTable Cache Data </th><th>122</th></tr>
<tr> <td>4 </td> <td>numDate</td> <td>8</td> <td>Date the PivotTable cache was created or was last refreshed. The date is stored as an 8-byte IEEE floating-point number.</td></tr>
<tr> <td>12 </td> <td>cSxFormula</td> <td>4</td> <td>Count of SXFORMULA records for this cache.</td></tr>
</table>

<table>
<tr><th>SXDI</th><th>Data Item </th><th>C5</th></tr>
<tr> <td>4 </td> <td>isxvdData</td> <td>2</td> <td>Field that this data item is based on.</td></tr>
<tr> <td>6 </td> <td>iiftab</td> <td>2</td> <td>Index to the aggregation function: =00h, Sum =01h, Count =02h, Average =03h, Max =04h, Min =05h, Product =06h, Count Nums =07h, StdDev =08h, StdDevp =09h, Var =0Ah, Varp</td></tr>
<tr> <td>8 </td> <td>df</td> <td>2</td> <td>Data display format: =00h, Normal =01h, Difference from =02h, Percentage of =03h, Percentage difference from =04h, Running total in =05h, Percentage of row =06h, Percentage of column =07h, Percentage of total =08h, Index</td></tr>
<tr> <td>10 </td> <td>isxvd</td> <td>2</td> <td>Index to the SXVD record used by the data display format.</td></tr>
<tr> <td>12 </td> <td>isxvi</td> <td>2</td> <td>Index to the SXVI record used by the data display format.</td></tr>
<tr> <td>14 </td> <td>ifmt</td> <td>2</td> <td>Index to the format table for this item.</td></tr>
<tr> <td>16 </td> <td>cchName</td> <td>2</td> <td>Length of the name; if the name =FFFFh, rgch is null and the name in the PivotTable cache storage is used.</td></tr>
<tr> <td>18 </td> <td>rgch</td> <td>var</td> <td>Name.</td></tr>
</table>

<table>
<tr><th>SXDXF</th><th>PivotTable Formatting </th><th>F4</th></tr>
<tr> <td>4 </td> <td>rgbdxf</td> <td>var</td> <td>PivotTable formatting to apply (refer to DXF documentation at the end of the XF record)</td></tr>
</table>

<table>
<tr><th>SXEX</th><th>PivotTable View Extended Information </th><th>F1</th></tr>
<tr> <td>4 </td> <td>csxformat</td> <td>2</td> <td>Number of SXFORMAT records to follow</td></tr>
<tr> <td>6 </td> <td>cchErrorString</td> <td>2</td> <td>Number of characters for DisplayErrorString string</td></tr>
<tr> <td>8 </td> <td>cchNullString</td> <td>2</td> <td>Number of characters for DisplayNullString string</td></tr>
<tr> <td>10 </td> <td>cchTag</td> <td>2</td> <td>Number of characters in Tag string</td></tr>
<tr> <td>12 </td> <td>csxselect</td> <td>2</td> <td>Number of RTSXSELECT records to follow</td></tr>
<tr> <td>14 </td> <td>crwPage</td> <td>2</td> <td>Number of page field per row</td></tr>
<tr> <td>16 </td> <td>ccolPage</td> <td>2</td> <td>Number of page field per column</td></tr>
<tr> <td>18 </td> <td>grbit1</td> <td>2</td> <td>=0001h, fAcrossPageLay =01FEh, cWrapPage =0200h, fPreserveFormattingNow =0400h, fManualUpdate</td></tr>
<tr> <td>20 </td> <td>grbit2</td> <td>2</td> <td>=0001h, fEnableWizard =0002h, fEnableDrilldown =0004h, fEnableFieldDialog =0008h, fPreserveFormatting =0010h, fMergeLabels =0020h, fDisplayErrorString =0040h, fDisplayNullString =0080h, fSubtotalHiddenPageItems =0100h, (unused) =0200h, FEnableDataEd =0400h, fDisableFList</td></tr>
<tr> <td>22 </td> <td>cchPageFieldStyle</td> <td>2</td> <td>Number of characters in page field style string</td></tr>
<tr> <td>24 </td> <td>cchTableStyle</td> <td>2</td> <td>Number of characters for table style string</td></tr>
<tr> <td>26 </td> <td>cchVacateStyle</td> <td>2</td> <td>Number of characters for vacate style string</td></tr>
<tr> <td>28 </td> <td>rgb</td> <td>var</td> <td>Array of characters for ErrorString, NullString, Tag, PageFieldStyle, TableStyle, VacateStyle</td></tr>
</table>

<table>
<tr><th>SXEXT</th><th>External Source Information </th><th>DC</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Options flags; see following table</td></tr>
<tr> <td>6 </td> <td>cparams</td> <td>2</td> <td>Number of parameter strings</td></tr>
<tr> <td>8 </td> <td>cstQuery</td> <td>2</td> <td>Number of strings for SQL statement or URL</td></tr>
<tr> <td>10 </td> <td>cstWebPost</td> <td>2</td> <td>Number of strings for post method of Web query</td></tr>
<tr> <td>12 </td> <td>cstSQLSav</td> <td>2</td> <td>Number of strings for SQL statement for server-based page fields</td></tr>
<tr> <td>14 </td> <td>cstOdbcConn</td> <td>2</td> <td>Number of strings for ODBC connection string</td></tr>
</table>

<table>
<tr><th>SXFDBTYPE</th><th>SQL Datatype Identifier </th><th>1BB</th></tr>
<tr> <td>4 </td> <td>wTypeSql</td> <td>2</td> <td>The SQL datatype of the field described in the immediately preceding SXFDB record. These are the same values as found in the ODBC SDK. See the SQL datatypes in SQL.H</td></tr>
</table>

<table>
<tr><th>SXFILT</th><th>PivotTable Rule Filter </th><th>F2</th></tr>
<tr> <td>4 </td> <td>grbit1</td> <td>2</td> <td>=0001h, fRwField, field is in row area. =0002h, fColumnField, field is in column area. =0004h, fPageField, field is in page area. =0008h, fDataField, field is in data area. =0030h, (reserved) =FFC0h, iDim.</td></tr>
<tr> <td>8 </td> <td>grbit2</td> <td>2</td> <td>=03FFh, isxvd. =FC00h, (reserved)</td></tr>
</table>

<table>
<tr><th>SXFMLA</th><th>PivotTable Parsed Expression </th><th>F9</th></tr>
<tr> <td>4 </td> <td>cce</td> <td>2</td> <td>Size of rgce</td></tr>
<tr> <td>6 </td> <td>csxname</td> <td>2</td> <td>Number of RTSXNAME records to follow this record</td></tr>
<tr> <td>8 </td> <td>rgce</td> <td>var</td> <td>Parsed expressed whose size is given by cce</td></tr>
</table>

<table>
<tr><th>SXFORMAT</th><th>PivotTable Format Record </th><th>FB</th></tr>
<tr> <td>4 </td> <td>rlType</td> <td>2</td> <td>=0h, clear =1h, format applied</td></tr>
<tr> <td>6 </td> <td>cbData</td> <td>2</td> <td>Length of formatting data in the SXDXF record that follows this record</td></tr>
</table>

<table>
<tr><th>SXFORMULA</th><th>PivotTable Formula Record </th><th>103</th></tr>
<tr> <td>4 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved. Should be set to zero.</td></tr>
<tr> <td>6 </td> <td>ifdb</td> <td>2</td> <td>1 if the calculated item formula applies to all fields, or, if positive, the field that this calculated item formula applies to.</td></tr>
</table>

<table>
<tr><th>SXIDSTM</th><th>Stream ID </th><th>D5</th></tr>
<tr> <td>4 </td> <td>idstm</td> <td>2</td> <td>Stream ID</td></tr>
</table>

<table>
<tr><th>SXITM</th><th>PivotTable Item Indexes </th><th>F5</th></tr>
<tr> <td>4 </td> <td>rgisxvi</td> <td>var</td> <td>Array of PivotTable item indexes</td></tr>
</table>

<table>
<tr><th>SXIVD</th><th>Row/Column Field IDs </th><th>B4</th></tr>
<tr> <td>4 </td> <td>rgisxvd</td> <td>var</td> <td>Array of 2-byte integers; contains either row field IDs or column field IDs</td></tr>
</table>

<table>
<tr><th>SXLI</th><th>Line Item Array </th><th>B5</th></tr>
<tr> <td>4 </td> <td>rgsxli</td> <td>var</td> <td>Array of SXLI structures</td></tr>
</table>

<table>
<tr><th>SXNAME</th><th>PivotTable Name </th><th>F6</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>=02h, fErrName, the name is invalid and should be displayed and evaluated as #NAME.</td></tr>
<tr> <td>6 </td> <td>ifdb</td> <td>2</td> <td>Field to aggregate in calculated field formulas.</td></tr>
<tr> <td>8 </td> <td>ifn</td> <td>2</td> <td>Function to use for aggregation in calculated field formulas. =01h, SUM =02h, COUNTA =03h, AVERAGE =04h, MAX =05h, MIN =06h, PRODUCT =07h, COUNT =08h, STDEV =09h, STDEVP =0Ah, VAR =0Bh, VARP</td></tr>
<tr> <td>10 </td> <td>csxpair</td> <td>2</td> <td>Number of SXPAIR records to follow this record.</td></tr>
</table>

<table>
<tr><th>SXPAIR</th><th>PivotTable Name Pair </th><th>F8</th></tr>
<tr> <td>4 </td> <td>isxvd</td> <td>2</td> <td>Field.</td></tr>
<tr> <td>6 </td> <td>iCache</td> <td>2</td> <td>Index of item in field.</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved, should be set to zero.</td></tr>
<tr> <td>10 </td> <td>grbit</td> <td>2</td> <td>=01h, fCalculatedItem. =06h, reserved. =08h, fPhysical, item is referred to by position (physical) rather than by name (logical) =10h, fRelative, if fPhysical is true, then item is referred to using relative references rather than absolute references.</td></tr>
</table>

<table>
<tr><th>SXPI</th><th>Page Item </th><th>B6</th></tr>
<tr> <td>4 </td> <td>isxvi</td> <td>2</td> <td>Index to the SXVI record for the page item</td></tr>
<tr> <td>6 </td> <td>isxvd</td> <td>2</td> <td>Index to the SXVD record for the page item</td></tr>
<tr> <td>8 </td> <td>idObj</td> <td>2</td> <td>Object ID for the page item drop-down arrow</td></tr>
</table>

<table>
<tr><th>SXPIEX</th><th>OLAP Page Item Extensions </th><th>80E</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Eh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>isxth</td> <td>4</td> <td>The index of the SXTH record which gives the hierarchy that is in this page field orientation</td></tr>
<tr> <td>12 </td> <td>stUnique</td> <td>var</td> <td>Unicode string; the unique name of the Page Item</td></tr>
<tr> <td>var </td> <td>stDisplay</td> <td>var</td> <td>Unicode string; the display name of the Page Item</td></tr>
</table>

<table>
<tr><th>SXRULE</th><th>PivotTable Rule Data </th><th>F0</th></tr>
<tr> <td>4 </td> <td>iDim</td> <td>1</td> <td>Position of current field in axis.</td></tr>
<tr> <td>5 </td> <td>isxvd</td> <td>1</td> <td>Current field.</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>see table below</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>2</td> <td></td></tr>
<tr> <td>10 </td> <td>csxfilt</td> <td>2</td> <td>Number of SXFILT records following this record.</td></tr>
<tr> <td>12 </td> <td>irwFirst</td> <td>1</td> <td>When grbit.fPart=1, relative zero-based first/last row/column offsets from the first cell in the area to the first cell in the partial area.</td></tr>
<tr> <td>13 </td> <td>irwLast</td> <td>1</td> <td>No definition</td></tr>
<tr> <td>14 </td> <td>icolFirst</td> <td>1</td> <td>No definition</td></tr>
<tr> <td>15 </td> <td>icolLast</td> <td>1</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXSELECT</th><th>PivotTable Selection Information </th><th>F7</th></tr>
<tr> <td>4 </td> <td>iwnx</td> <td>2</td> <td>0-based index of the window of the sheet</td></tr>
<tr> <td>6 </td> <td>pnn</td> <td>2</td> <td>0-based index of the pane of the window</td></tr>
<tr> <td>8 </td> <td>sxaxisAct</td> <td>2</td> <td>The PivotTable area the selection is on =0h, no PivotTable area =1h, row area =2h, column area =4h, page area =8h, data area</td></tr>
<tr> <td>10 </td> <td>iDimAct</td> <td>2</td> <td>Which field (zero-based index) within the PivotTable area the selection operation started on</td></tr>
<tr> <td>12 </td> <td>iLiStart</td> <td>2</td> <td>0-based index of the PivotTable line where the selection operation started</td></tr>
<tr> <td>14 </td> <td>iLiAct</td> <td>2</td> <td>0-based index of the PivotTable line that was most recently included in the selection</td></tr>
<tr> <td>16 </td> <td>iLiMin</td> <td>2</td> <td>0-based index of the first possible PivotTable line that could be included into the current selection</td></tr>
<tr> <td>18 </td> <td>iLiMax</td> <td>2</td> <td>0-based index of the last possible PivotTable line that could be included into the current selection</td></tr>
<tr> <td>20 </td> <td>rwClick</td> <td>2</td> <td>0-based row/column coordinates of the cell where the user last clicked the PivotTable selection</td></tr>
<tr> <td>22 </td> <td>colClick</td> <td>2</td> <td>No definition</td></tr>
<tr> <td>24 </td> <td>rwClickPrev</td> <td>2</td> <td>0-based row/column coordinates of the cell where the user previous clicked the PivotTable selection</td></tr>
<tr> <td>26 </td> <td>colClickPrev</td> <td>2</td> <td>No definition</td></tr>
<tr> <td>28 </td> <td>grbit</td> <td>2</td> <td>PivotTable selection properties and flags</td></tr>
</table>

<table>
<tr><th>SXSTRING</th><th>String </th><th>CD</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>2</td> <td>Length of the string</td></tr>
<tr> <td>6 </td> <td>rgch</td> <td>var</td> <td>String</td></tr>
</table>

<table>
<tr><th>SXTBL</th><th>Multiple Consolidation Source Info </th><th>D0</th></tr>
<tr> <td>4 </td> <td>cdref</td> <td>2</td> <td>Count (1-based) of DCONREF or DCONNAME records that follow the SXTBL record</td></tr>
<tr> <td>6 </td> <td>csxtbpg</td> <td>2</td> <td>Count (1-based) of SXTBPG records that follow the DCONREF or DCONNAME records</td></tr>
<tr> <td>8 </td> <td>grbitPages</td> <td>2</td> <td>(See the following table)</td></tr>
</table>

<table>
<tr><th>SXTBPG</th><th>Page Item Indexes </th><th>D2</th></tr>
<tr> <td>4 </td> <td>rgiitem</td> <td>var</td> <td>Array of 2-byte indexes to page items (iitem)</td></tr>
</table>

<table>
<tr><th>SXTBRGIITM</th><th>Page Item Name Count </th><th>D1</th></tr>
<tr> <td>4 </td> <td>cItems</td> <td>2</td> <td>Number of page item names (number of SXTBRGIITM records that follow)</td></tr>
</table>

<table>
<tr><th>SXTH</th><th>Pivot Table OLAP Hierarchy </th><th>80D</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Dh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>dwFlags</td> <td>4</td> <td>OLAP options; see following table</td></tr>
<tr> <td>12 </td> <td>sxaxis</td> <td>4</td> <td>The ID of the axis element; 1= sxaxisRw; the row header region of the PivotTable 2= sxaxisCol; the column header region of the PivotTable 4= sxaxisPage; the page field dropdown of the PivotTable 8= sxaxisData; the body of the PivotTable</td></tr>
<tr> <td>16 </td> <td>isxvd</td> <td>4</td> <td>Index into array of dimensions; these are loaded in the SXVD records; only applicable if the sxaxis is sxaxisPage or sxaxisData</td></tr>
<tr> <td>20 </td> <td>csxvdXl</td> <td>4</td> <td>Count of fields fetched from the OLAP database</td></tr>
<tr> <td>24 </td> <td>sxDragTh</td> <td>2</td> <td>Field drag flags; see following table</td></tr>
<tr> <td>26 </td> <td>stUnique</td> <td>var</td> <td>Unicode string; Unique name for the hierarchy</td></tr>
<tr> <td>var </td> <td>stDisplay</td> <td>var</td> <td>Unicode string; Display name for the hierarchy</td></tr>
<tr> <td>var </td> <td>stDefaultUnique</td> <td>var</td> <td>Unicode string; Unique name of the default member</td></tr>
<tr> <td>var </td> <td>stAllUnique</td> <td>var</td> <td>Unicode string; Unique name of the All member</td></tr>
<tr> <td>var </td> <td>stDimensionUnique</td> <td>var</td> <td>Unicode string; Unique name of the dimension</td></tr>
<tr> <td>var </td> <td>cisxvd</td> <td>4</td> <td>Count of isxvd items in the rgb field; this has the same value as csxvdXl</td></tr>
<tr> <td>var </td> <td>rgisxvd</td> <td>var</td> <td>Set of isxvd items; each is a 4-byte identifier that points to a specific SXVD record</td></tr>
<tr> <td>var </td> <td>rgb</td> <td>var</td> <td>Set of strings describing which members have been hidden; see text below</td></tr>
</table>

<table>
<tr><th>SXVD</th><th>View Fields </th><th>B1</th></tr>
<tr> <td>4 </td> <td>sxaxis</td> <td>2</td> <td>Axis: =0, no axis =1, row =2, column =4, page =8, data</td></tr>
<tr> <td>6 </td> <td>cSub</td> <td>2</td> <td>Number of subtotals attached.</td></tr>
<tr> <td>8 </td> <td>grbitSub</td> <td>2</td> <td>Item subtotal type (see the following table).</td></tr>
<tr> <td>10 </td> <td>cItm</td> <td>2</td> <td>Number of items.</td></tr>
<tr> <td>12 </td> <td>cchName</td> <td>2</td> <td>Length of the name; if the name =FFFFh, rgch is null and the name in the cache is used.</td></tr>
<tr> <td>14 </td> <td>rgch</td> <td>var</td> <td>Name.</td></tr>
</table>

<table>
<tr><th>SXVDEX</th><th>Extended PivotTable View Fields </th><th>100</th></tr>
<tr> <td>4 </td> <td>grbit1</td> <td>4</td> <td>=0001h, fShowAllItems show all items for this field. =0002h, fDragToRow user can drag field to row area. =0004h, fDragToColumn user can drag field to column area. =0008h, fDragToPage user can drag field to page area. =0010h, fDragToHide user can remove field from view. =0060h, reserved. =0080h, fServerBased this field is a server-based field in the page area. =0100h, reserved. =0200h, fAutoSort autosort is enabled. =0400h, fAscendSort autosort ascending. =0800h, fAutoShow autoshow is enabled. =1000h, fAscendShow show top values. =2000h, fCalculatedField calculated field. XL9: =4000h, fPageBreaksBetweenItems a page break is put between item changes in the Pivot Table view XL9: =8000h, fHideNewItems new items that come in during a Pivot Table refresh are not shown in the view by default</td></tr>
<tr> <td>8 </td> <td>grbit2</td> <td>1</td> <td>=1Fh, reserved. XL9: =20h, fOutline layout this field in outline form on the Pivot Table view XL9: =40h, fInsertBlankRow a blank line is put between item changes in the Pivot Table view XL9: =80h, fSubtotalAtTop - when fOutline=1 then display subtotals at the top of the list of items instead of at the bottom</td></tr>
<tr> <td>9 </td> <td>citmShow</td> <td>1</td> <td>Number of items to show for AutoShow, default is 10.</td></tr>
<tr> <td>10 </td> <td>isxdiSort</td> <td>2</td> <td>0-based index of data field that AutoSort is based on or 1 for current field.</td></tr>
<tr> <td>12 </td> <td>isxdiShow</td> <td>2</td> <td>0-based index of data field that AutoShow is based on.</td></tr>
<tr> <td>14 </td> <td>ifmt</td> <td>2</td> <td>Number format of field or 0 if none.</td></tr>
<tr> <td>16 </td> <td>cchSubName</td> <td>2</td> <td>XL9: Length of unicode string in stSubName. FFh means no custom subtotal name was specified</td></tr>
<tr> <td>18 </td> <td>(Reserved)</td> <td>4</td> <td>XL9:</td></tr>
<tr> <td>22 </td> <td>(Reserved)</td> <td>4</td> <td>XL9:</td></tr>
<tr> <td>26 </td> <td>stSubName</td> <td>var</td> <td>XL9: Custom subtotal name represented in unicode</td></tr>
</table>

<table>
<tr><th>SXVDTEX</th><th>View Dimension OLAP Extensions </th><th>80F</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Fh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>wTensorFlags</td> <td>2</td> <td>OLAP options; see following table</td></tr>
<tr> <td>10 </td> <td>isxth</td> <td>2</td> <td>Which OLAP hierarchy</td></tr>
<tr> <td>12 </td> <td>isxtl</td> <td>4</td> <td>OLAP level</td></tr>
<tr> <td>16 </td> <td>csxvi</td> <td>4</td> <td>Count of 2-byte items in rgsxvi</td></tr>
<tr> <td>20 </td> <td>rgsxvi</td> <td>var</td> <td>Sets of PivotTable item flags; see following table for flags</td></tr>
</table>

<table>
<tr><th>SXVI</th><th>View Item </th><th>B2</th></tr>
<tr> <td>4 </td> <td>itmtype</td> <td>2</td> <td>Item type: =FEh, Page =FFh, Null =00h, Data =01h, Default =02h, SUM =03h, COUNTA =04h, COUNT =05h, AVERAGE =06h, MAX =07h, MIN =08h, PRODUCT =09h, STDEV =0Ah, STDEVP =0Bh, VAR =0Ch, VARP =0Dh, Grand total XL9: =0Eh, blank</td></tr>
<tr> <td>6 </td> <td>grbit</td> <td>2</td> <td>Option flags.</td></tr>
<tr> <td>8 </td> <td>iCache</td> <td>2</td> <td>Index to the PivotTable cache.</td></tr>
<tr> <td>10 </td> <td>cchName</td> <td>2</td> <td>Length of the name; if the name =FFFFh, rgch is null and the name in the cache is used.</td></tr>
<tr> <td>12 </td> <td>rgch</td> <td>var</td> <td>Name.</td></tr>
</table>

<table>
<tr><th>SXVIEW</th><th>View Definition </th><th>B0</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row of the PivotTable</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row of the PivotTable</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>2</td> <td>First column of the PivotTable</td></tr>
<tr> <td>10 </td> <td>colLast</td> <td>2</td> <td>Last column of the PivotTable</td></tr>
<tr> <td>12 </td> <td>rwFirstHead</td> <td>2</td> <td>First row containing PivotTable headings</td></tr>
<tr> <td>14 </td> <td>rwFirstData</td> <td>2</td> <td>First row containing PivotTable data</td></tr>
<tr> <td>16 </td> <td>colFirstData</td> <td>2</td> <td>First column containing PivotTable data</td></tr>
<tr> <td>18 </td> <td>iCache</td> <td>2</td> <td>Index to the cache</td></tr>
<tr> <td>20 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be 0 (zero)</td></tr>
<tr> <td>22 </td> <td>sxaxis4Data</td> <td>2</td> <td>Default axis for a data field</td></tr>
<tr> <td>24 </td> <td>ipos4Data</td> <td>2</td> <td>Default position for a data field</td></tr>
<tr> <td>26 </td> <td>cDim</td> <td>2</td> <td>Number of fields</td></tr>
<tr> <td>28 </td> <td>cDimRw</td> <td>2</td> <td>Number of row fields</td></tr>
<tr> <td>30 </td> <td>cDimCol</td> <td>2</td> <td>Number of column fields</td></tr>
<tr> <td>32 </td> <td>cDimPg</td> <td>2</td> <td>Number of page fields</td></tr>
<tr> <td>34 </td> <td>cDimData</td> <td>2</td> <td>Number of data fields</td></tr>
<tr> <td>36 </td> <td>cRw</td> <td>2</td> <td>Number of data rows</td></tr>
<tr> <td>38 </td> <td>cCol</td> <td>2</td> <td>Number of data columns</td></tr>
<tr> <td>40 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>42 </td> <td>itblAutoFmt</td> <td>2</td> <td>Index to the PivotTable autoformat</td></tr>
<tr> <td>44 </td> <td>cchName</td> <td>2</td> <td>Length of the PivotTable name</td></tr>
<tr> <td>46 </td> <td>cchData</td> <td>2</td> <td>Length of the data field name</td></tr>
<tr> <td>48 </td> <td>rgch</td> <td>var</td> <td>PivotTable name, followed by the name of a data field</td></tr>
</table>

<table>
<tr><th>SXVIEWEX</th><th>Pivot Table OLAP Extensions </th><th>80C</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Ch</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>csxth</td> <td>4</td> <td>Count of SXTH records</td></tr>
<tr> <td>12 </td> <td>csxpi</td> <td>4</td> <td>Count of SXPIEX records</td></tr>
<tr> <td>16 </td> <td>csvdtex</td> <td>4</td> <td>Count of SXVDTEX records</td></tr>
<tr> <td>20 </td> <td>cbFuture</td> <td>4</td> <td>Count of bytes from future versions of Excel</td></tr>
<tr> <td>24 </td> <td>rgbFuture</td> <td>var</td> <td>Information from future versions of Excel</td></tr>
</table>

<table>
<tr><th>SXVIEWEX9</th><th>Pivot Table Extensions </th><th>810</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0810h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be zero</td></tr>
<tr> <td>12 </td> <td>grbit</td> <td>4</td> <td>Options; see following table</td></tr>
<tr> <td>16 </td> <td>itblAutoFmt</td> <td>2</td> <td>Index to the PivotTable autoformat</td></tr>
<tr> <td>18 </td> <td>chGrand</td> <td>var</td> <td>Unicode string; the Grand Total name</td></tr>
</table>

<table>
<tr><th>SXVS</th><th>View Source </th><th>E3</th></tr>
<tr> <td>4 </td> <td>vs</td> <td>2</td> <td>Data source: =01h, Excel list or database =02h, External data source (Microsoft Query) =04h, Multiple consolidation ranges =10h, A Scenario Manager summary report</td></tr>
</table>

<table>
<tr><th>TABID</th><th>Sheet Tab Index Array </th><th>13D</th></tr>
<tr> <td>4 </td> <td>rgiTab</td> <td>var</td> <td>Array of tab indexes</td></tr>
</table>

<table>
<tr><th>TABIDCONF</th><th>Sheet Tab ID of Conflict History </th><th>EA</th></tr>
<tr> <td>4 </td> <td>itabConf</td> <td>2</td> <td>Sheet tab index for the Conflict History worksheet. If =FFFFh, the user has stopped sharing the workbook.</td></tr>
</table>

<table>
<tr><th>TABLE</th><th>Data Table </th><th>236</th></tr>
<tr> <td>4 </td> <td>rwFirst</td> <td>2</td> <td>First row of the table</td></tr>
<tr> <td>6 </td> <td>rwLast</td> <td>2</td> <td>Last row of the table</td></tr>
<tr> <td>8 </td> <td>colFirst</td> <td>1</td> <td>First column of the table</td></tr>
<tr> <td>9 </td> <td>colLast</td> <td>1</td> <td>Last column of the table</td></tr>
<tr> <td>10 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>12 </td> <td>rwInpRw</td> <td>2</td> <td>Row of the row input cell</td></tr>
<tr> <td>14 </td> <td>colInpRw</td> <td>2</td> <td>Column of the row input cell</td></tr>
<tr> <td>16 </td> <td>rwInpCol</td> <td>2</td> <td>Row of the column input cell</td></tr>
<tr> <td>18 </td> <td>colInpCol</td> <td>2</td> <td>Column of the column input cell</td></tr>
</table>

<table>
<tr><th>TABLESTYLE</th><th>Table Style </th><th>88F</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Fh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>grbitTS</td> <td>2</td> <td>see below</td></tr>
<tr> <td>18 </td> <td>ctse</td> <td>4</td> <td>Count of TABLESTYLEELEMENT records to follow.</td></tr>
<tr> <td>22 </td> <td>cchName</td> <td>2</td> <td>Length of Table style name in 2 byte characters.</td></tr>
<tr> <td>24 </td> <td>rgchName</td> <td>var</td> <td>Table style name in 2 byte characters</td></tr>
</table>

<table>
<tr><th>TABLESTYLEELEMENT</th><th>Table Style Element </th><th>890</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0890h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>tseType</td> <td>4</td> <td>Type of table style element</td></tr>
<tr> <td>20 </td> <td>size</td> <td>4</td> <td>Number of items in each band for row or column stripped elements.</td></tr>
<tr> <td>24 </td> <td>dxfid</td> <td>4</td> <td>Index of DXF record with formatting for this table style element.</td></tr>
</table>

<table>
<tr><th>TABLESTYLES</th><th>Table Styles </th><th>88E</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =088Eh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>cts</td> <td>4</td> <td>count of TABLESTYLE records to follow</td></tr>
<tr> <td>20 </td> <td>cchDefListStyle</td> <td>2</td> <td>Length of default list table style name in 2 byte characters</td></tr>
<tr> <td>22 </td> <td>cchDefPivotStyle</td> <td>2</td> <td>Length of default pivot table style name in 2 byte characters.</td></tr>
<tr> <td>24 </td> <td>rgchDefListStyle</td> <td>var</td> <td>default list table style name</td></tr>
<tr> <td>var </td> <td>rgchDefPivotStyle</td> <td>var</td> <td>default pivot table style name</td></tr>
</table>

<table>
<tr><th>TEMPLATE</th><th>Workbook Is a Template </th><th>60</th></tr>
</table>

<table>
<tr><th>THEME</th><th>Theme </th><th>896</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0896h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>dwThemeVersion</td> <td>8</td> <td>default theme version; =0 if custom theme</td></tr>
<tr> <td>24 </td> <td>rgb</td> <td>var</td> <td>beginning of serialized package bytes</td></tr>
</table>

<table>
<tr><th>TOPMARGIN</th><th>Top Margin Measurement </th><th>28</th></tr>
<tr> <td>4 </td> <td>num</td> <td>8</td> <td>Top margin</td></tr>
</table>

<table>
<tr><th>TXO</th><th>Text Object </th><th>1B6</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags; see following table</td></tr>
<tr> <td>6 </td> <td>rot</td> <td>2</td> <td>Orientation of text within the object boundary: =0, no rotation (text appears left to right) =1, text appears top to bottom; letters are upright =2, text is rotated 90 degrees counterclockwise =3, text is rotated 90 degrees clockwise</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>6</td> <td>Reserved; must be 0 (zero)</td></tr>
<tr> <td>14 </td> <td>cchText</td> <td>2</td> <td>Length (in characters) of text (in first CONTINUE record)</td></tr>
<tr> <td>16 </td> <td>cbRuns</td> <td>2</td> <td>Length of formatting runs (in second CONTINUE record)</td></tr>
<tr> <td>14 </td> <td>(Reserved)</td> <td>4</td> <td>Reserved; must be 0 (zero)</td></tr>
</table>

<table>
<tr><th>TXTQUERY</th><th>Text Query Information </th><th>805</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0805h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>Options; see following table</td></tr>
<tr> <td>10 </td> <td>rowStartAt</td> <td>4</td> <td>Row in source file where where the query information starts</td></tr>
<tr> <td>14 </td> <td>delimFlags</td> <td>4</td> <td>Delimiter flags; see following table</td></tr>
<tr> <td>18 </td> <td>itwf</td> <td>4</td> <td>Fields in each row of data</td></tr>
<tr> <td>22 </td> <td>chDecimal</td> <td>1</td> <td>ANSI character; which character is used for the decimal separator</td></tr>
</table>

<table>
<tr><th>UDDESC</th><th>Description String for Chart Autoformat </th><th>DF</th></tr>
<tr> <td>4 </td> <td>cch</td> <td>1</td> <td>Length of the description string</td></tr>
<tr> <td>5 </td> <td>rgch</td> <td>var</td> <td>Description string</td></tr>
</table>

<table>
<tr><th>UNCALCED</th><th>Recalculation Status </th><th>5E</th></tr>
<tr> <td>4 </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be 0 (zero)</td></tr>
</table>

<table>
<tr><th>USERBVIEW</th><th>Workbook Custom View Settings </th><th>1A9</th></tr>
<tr> <td>4 </td> <td>iViewId</td> <td>4</td> <td>ID for the custom view.</td></tr>
<tr> <td>8 </td> <td>iTabid</td> <td>4</td> <td>Tab index for the active sheet (1-based).</td></tr>
<tr> <td>12 </td> <td>guid</td> <td>16</td> <td>Globally unique identifier for the custom view.</td></tr>
<tr> <td>28 </td> <td>x</td> <td>4</td> <td>Horizontal position of window.</td></tr>
<tr> <td>32 </td> <td>y</td> <td>4</td> <td>Vertical position of window.</td></tr>
<tr> <td>36 </td> <td>dx</td> <td>4</td> <td>Width of window.</td></tr>
<tr> <td>40 </td> <td>dy</td> <td>4</td> <td>Height of window.</td></tr>
</table>

<table>
<tr><th>USERSVIEWBEGIN</th><th>Custom View Settings </th><th>1AA</th></tr>
<tr> <td>4 </td> <td>guid</td> <td>16</td> <td>Globally unique identifier for the custom view</td></tr>
<tr> <td>20 </td> <td>iTabid</td> <td>4</td> <td>Tab index for the sheet (1-based)</td></tr>
<tr> <td>24 </td> <td>wScale</td> <td>4</td> <td>Window zoom magnification</td></tr>
<tr> <td>28 </td> <td>icv</td> <td>4</td> <td>Index to color value</td></tr>
<tr> <td>32 </td> <td>pnnSel</td> <td>4</td> <td>Pane number of the active pane</td></tr>
<tr> <td>36 </td> <td>grbit</td> <td>4</td> <td>Option flags</td></tr>
<tr> <td>40 </td> <td>refTopLeft</td> <td>8</td> <td>Reference structure describing the visible area of the top-left pane (see text)</td></tr>
<tr> <td>48 </td> <td>operNum</td> <td>16</td> <td>Array of 2 IEEE floating-point numbers that specify the vertical and horizontal positions of the pane split</td></tr>
<tr> <td>64 </td> <td>colRPane</td> <td>2</td> <td>The first visible column of the right pane (=1 implies no vertical split)</td></tr>
<tr> <td>66 </td> <td>rwBPane</td> <td>2</td> <td>The first visible of the bottom pane (=1 implies no horizontal split)</td></tr>
</table>

<table>
<tr><th>USERSVIEWEND</th><th>End of Custom View Records </th><th>1AB</th></tr>
<tr> <td>4 </td> <td>fValid</td> <td>2</td> <td>=1 if the view settings saved are valid</td></tr>
</table>

<table>
<tr><th>USESELFS</th><th>Natural Language Formulas Flag </th><th>160</th></tr>
<tr> <td>4 </td> <td>fUsesElfs</td> <td>2</td> <td>=1 if this file was written by a version of Excel that can use natural-language formula input</td></tr>
</table>

<table>
<tr><th>VCENTER</th><th>Center Between Vertical Margins </th><th>84</th></tr>
<tr> <td>4 </td> <td>fVCenter</td> <td>2</td> <td>=1 if the sheet is to be centered between the vertical margins when printed</td></tr>
</table>

<table>
<tr><th>VERTICALPAGEBREAKS</th><th>Explicit Column Page Breaks </th><th>1A</th></tr>
<tr> <td>4 </td> <td>cbrk</td> <td>2</td> <td>Number of page breaks</td></tr>
<tr> <td>6 </td> <td>rgbrk</td> <td>var</td> <td>Array of brk structures</td></tr>
</table>

<table>
<tr><th>WEBPUB</th><th>Web Publish Item </th><th>801</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; = 0801h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; see FRT Records for more information</td></tr>
<tr> <td>8 </td> <td>ref</td> <td>var</td> <td>Range reference; see FRT Records for more information</td></tr>
<tr> <td>var </td> <td>tws</td> <td>1</td> <td>Type of Web Source: 1= twsSheet; Entire Sheet was published 2= twsPrintArea; the Print Area was published 3= twsAutoFilter; an AutoFilter was published 4= twsRef; a range of cells was published 5= twsChart; a Chart was published 6= twsPivotTable; a PivotTable was published 7= twsQuery; a Query Table was published 8= twsLabel; a named range was published</td></tr>
<tr> <td>var </td> <td>twd</td> <td>1</td> <td>Type of Web Page created: 0= twdHtmlPlain; non-interactive page 1= twdHtmlCalc; page uses Spreadsheet functionality 2= twdHtmlList; page uses PivotTable functionality 3= twdHtmlChart; page uses Chart functionality</td></tr>
<tr> <td>var </td> <td>grfOptions</td> <td>2</td> <td>Common options; see following table</td></tr>
<tr> <td>var </td> <td>(Reserved)</td> <td>2</td> <td>Reserved; must be zero</td></tr>
<tr> <td>var </td> <td>nStyled</td> <td>4</td> <td>Style number (usually the same as the number inside stDivId)</td></tr>
<tr> <td>var </td> <td>cb</td> <td>4</td> <td>Size of information that follows</td></tr>
<tr> <td>var </td> <td>stSrcName</td> <td>var</td> <td>Source data name (does not exist if tws is twsRef); zero length string if tws is a type that has no name (ie the item is the entire sheet or the AutoFilter)</td></tr>
<tr> <td>var </td> <td>stFileDest</td> <td>var</td> <td>Unicode string; name of the file that is written out; should never be zero length</td></tr>
<tr> <td>var </td> <td>stDivId</td> <td>var</td> <td>Unicode string identifier used for the DIV tag ID attribute; should never be zero length</td></tr>
<tr> <td>var </td> <td>stTitle</td> <td>var</td> <td>Unicode string; title for published data in the HTML file; can be zero length</td></tr>
<tr> <td>var </td> <td>idCrtShape</td> <td>var</td> <td>XL10: if tws=twsChart, this is a 4-byte chart shape id; otherwise this is zero length</td></tr>
<tr> <td>var </td> <td>rgb</td> <td>var</td> <td>Future information</td></tr>
</table>

<table>
<tr><th>WINDOW1</th><th>Window Information </th><th>3D</th></tr>
<tr> <td>4 </td> <td>xWn</td> <td>2</td> <td>Horizontal position of the window.</td></tr>
<tr> <td>6 </td> <td>yWn</td> <td>2</td> <td>Vertical position of the window.</td></tr>
<tr> <td>8 </td> <td>dxWn</td> <td>2</td> <td>Width of the window.</td></tr>
<tr> <td>10 </td> <td>dyWn</td> <td>2</td> <td>Height of the window.</td></tr>
<tr> <td>12 </td> <td>grbit</td> <td>2</td> <td>Option flags.</td></tr>
<tr> <td>14 </td> <td>itabCur</td> <td>2</td> <td>Index of the selected workbook tab (0-based).</td></tr>
<tr> <td>16 </td> <td>itabFirst</td> <td>2</td> <td>Index of the first displayed workbook tab (0-based).</td></tr>
<tr> <td>18 </td> <td>ctabSel</td> <td>2</td> <td>Number of workbook tabs that are selected.</td></tr>
<tr> <td>20 </td> <td>wTabRatio</td> <td>2</td> <td>Ratio of the width of the workbook tabs to the width of the horizontal scroll bar; to obtain the ratio, convert to decimal and then divide by 1000.</td></tr>
</table>

<table>
<tr><th>WINDOW2</th><th>Sheet Window Information </th><th>23E</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>6 </td> <td>rwTop</td> <td>2</td> <td>Top row visible in the window</td></tr>
<tr> <td>8 </td> <td>colLeft</td> <td>2</td> <td>Leftmost column visible in the window</td></tr>
<tr> <td>10 </td> <td>icvHdr</td> <td>4</td> <td>Index to color value for row/column headings and gridlines</td></tr>
<tr> <td>14 </td> <td>wScaleSLV</td> <td>2</td> <td>Zoom in pagebreak</td></tr>
<tr> <td>16 </td> <td>wScaleNormal</td> <td>2</td> <td>Zoom in normal</td></tr>
<tr> <td>18 </td> <td>Reserved</td> <td>4</td> <td>reserved</td></tr>
</table>

<table>
<tr><th>WINDOWPROTECT</th><th>Windows Are Protected </th><th>19</th></tr>
<tr> <td>4 </td> <td>fLockWn</td> <td>2</td> <td>=1 if the workbook windows are protected</td></tr>
</table>

<table>
<tr><th>WOPT</th><th>Web Options </th><th>80B</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =080Bh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>Options; see following table</td></tr>
</table>

<table>
<tr><th>WRITEACCESS</th><th>Write Access User Name </th><th>5C</th></tr>
<tr> <td>4 </td> <td>stName</td> <td>112</td> <td>User name as an unformatted unicode string . The name is always padded with spaces so the size of the stName field is exactly 112 bytes.</td></tr>
</table>

<table>
<tr><th>WRITEPROT</th><th>Workbook Is Write-Protected </th><th>86</th></tr>
</table>

<table>
<tr><th>WSBOOL</th><th>Additional Workspace Information </th><th>81</th></tr>
<tr> <td>4 </td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>XCT</th><th>CRN Record Count </th><th>59</th></tr>
<tr> <td>4 </td> <td>ccrn</td> <td>2</td> <td>Count of CRN records that follow</td></tr>
<tr> <td>6 </td> <td>itab</td> <td>2</td> <td>Index (0-based) to sheet tab associated with the CRN record(s)</td></tr>
</table>

<table>
<tr><th>XFCRC</th><th>XF Extensions Checksum </th><th>87C</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =087Ch</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>version</td> <td>2</td> <td>Record version; =0 currently</td></tr>
<tr> <td>18 </td> <td>cxfs</td> <td>2</td> <td>Number of XF records written to disk</td></tr>
</table>

<table>
<tr><th>XFEXT</th><th>XF Extension </th><th>87D</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =087Dh</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT cell reference flag; =0 currently</td></tr>
<tr> <td>8 </td> <td>(Reserved)</td> <td>8</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>16 </td> <td>version</td> <td>2</td> <td>Record version; =0 currently Office Excel 2007 will ignore this record on load if not 0.</td></tr>
<tr> <td>18 </td> <td>ixfe</td> <td>2</td> <td>Index of to XF record this extension modifies</td></tr>
<tr> <td>20 </td> <td>(Reserved)</td> <td>2</td> <td>Currently not used, and set to 0</td></tr>
<tr> <td>22 </td> <td>cexts</td> <td>2</td> <td>Number of extension properties that follow</td></tr>
<tr> <td>24 </td> <td>rgb</td> <td>var</td> <td>Array of extension properties.</td></tr>
</table>

<table>
<tr><th>INTEGER</th><th>unknown: </th><th>2</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FORMATCOUNT</th><th>unknown: </th><th>1F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>COLUMNDEFAULT</th><th>unknown: </th><th>20</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>COLWIDTH</th><th>unknown: </th><th>24</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WNBASIC (V1)</th><th>unknown: </th><th>2C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WNADV (V1)</th><th>unknown: </th><th>2D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PANE (V1)</th><th>unknown: </th><th>2E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FONTCOUNT</th><th>unknown: </th><th>30</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FONT2</th><th>unknown: </th><th>32</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PRINTSIZE</th><th>unknown: </th><th>33</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DDE ON (Debug)</th><th>unknown: </th><th>34</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>INFOOPTS</th><th>unknown: </th><th>35</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TABLE2</th><th>unknown: </th><th>37</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WNDESK</th><th>unknown: </th><th>38</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ZOOM</th><th>unknown: </th><th>39</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BEGINPREF</th><th>unknown: </th><th>3A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ENDPREF</th><th>unknown: </th><th>3B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PANE (V2)</th><th>unknown: </th><th>3F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>XF (V4)</th><th>unknown: </th><th>43</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>IXFE</th><th>unknown: </th><th>44</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EFONT</th><th>unknown: </th><th>45</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SHOWSCROLL</th><th>unknown: </th><th>46</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SHOWFORMULA</th><th>unknown: </th><th>47</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>STATUSBAR</th><th>unknown: </th><th>48</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SHORTMENUS</th><th>unknown: </th><th>49</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DDEENABLED</th><th>unknown: </th><th>4A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>AUTODEC</th><th>unknown: </th><th>4B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MENUKEY</th><th>unknown: </th><th>4C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MENUUND</th><th>unknown: </th><th>4E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MOVESEL</th><th>unknown: </th><th>4F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BUILTINFMTCOUNT</th><th>unknown: </th><th>56</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SUPER Code Page Table</th><th>unknown: </th><th>57</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBAR</th><th>unknown: </th><th>58</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>OBJ</th><th>Describes a Graphic Object </th><th>5D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>INTL</th><th>unknown: </th><th>61</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RTCLRTENTRY</th><th>unknown: </th><th>62</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MACROCH (MP)</th><th>unknown: </th><th>64</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WINDOW (MP)</th><th>unknown: </th><th>65</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>OPTIONS (MP)</th><th>unknown: </th><th>66</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RECEPT (MP)</th><th>unknown: </th><th>67</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>STYLE (MP)</th><th>unknown: </th><th>68</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>HEADER (MP)</th><th>unknown: </th><th>69</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FOOTER (MP)</th><th>unknown: </th><th>6A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PRINT (MP)</th><th>unknown: </th><th>6B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FORMULA (MP)</th><th>unknown: </th><th>6C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SPLIT (MP)</th><th>unknown: </th><th>6D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ALIAS (MP)</th><th>unknown: </th><th>6E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ECR (MP)</th><th>unknown: </th><th>6F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FORMAT (MP)</th><th>unknown: </th><th>70</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>STRING (MP)</th><th>unknown: </th><th>71</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SEL (MP)</th><th>unknown: </th><th>72</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>COLDEF (MP)</th><th>unknown: </th><th>73</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ROWDEF (MP)</th><th>unknown: </th><th>74</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>GRID (MP)</th><th>unknown: </th><th>75</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FMT (MP)</th><th>unknown: </th><th>76</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>NOTEOFF</th><th>unknown: </th><th>8A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>LH</th><th>unknown: </th><th>8B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BUNDLESOFFSET</th><th>unknown: </th><th>8E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BUNDLEHEADER</th><th>unknown: </th><th>8F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>LHRECORD</th><th>unknown: </th><th>94</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SYNC</th><th>unknown: </th><th>97</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>N/A</th><th>unknown: </th><th>9F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FNPROTO</th><th>unknown: </th><th>A2</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PROJEXTSHT</th><th>unknown: </th><th>A3</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBARVER</th><th>unknown: </th><th>A4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>IMOOM</th><th>unknown: </th><th>A5</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBARPOS</th><th>unknown: </th><th>A6</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBARDEF</th><th>unknown: </th><th>A7</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DRAGDROP</th><th>unknown: </th><th>A8</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DOCDIM</th><th>unknown: </th><th>AA</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTCOLORS</th><th>unknown: </th><th>AC</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MOVIE</th><th>unknown: </th><th>AD</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXSI</th><th>unknown: </th><th>B3</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FACENUM</th><th>unknown: </th><th>B7</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SSLIST</th><th>unknown: </th><th>BA</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MASKIMDATA</th><th>unknown: </th><th>BB</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBARHDR</th><th>unknown: </th><th>BF</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TOOLBAREND</th><th>unknown: </th><th>C0</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TIPHISTORY</th><th>unknown: </th><th>C4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXFDB</th><th>unknown: </th><th>C7</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXDDB</th><th>unknown: </th><th>C8</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXNUM</th><th>unknown: </th><th>C9</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXBOOL</th><th>unknown: </th><th>CA</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXERR</th><th>unknown: </th><th>CB</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXINT</th><th>unknown: </th><th>CC</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXDTR</th><th>unknown: </th><th>CE</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXNIL</th><th>unknown: </th><th>CF</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WSTGBOOK</th><th>unknown: </th><th>D4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXRNG</th><th>unknown: </th><th>D8</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXISXOPER</th><th>unknown: </th><th>D9</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>REVERT</th><th>unknown: </th><th>DB</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>XF</th><th>unknown: </th><th>E0</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RUNSFBI</th><th>unknown: </th><th>E4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EFCFORMULA</th><th>unknown: </th><th>E6</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EFCTEXTCOLOR</th><th>unknown: </th><th>E7</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EFCEXTLINK</th><th>unknown: </th><th>E8</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BKHIM</th><th>unknown: </th><th>E9</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PHONETICINFO</th><th>unknown: </th><th>EF</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXCI</th><th>unknown: </th><th>F3</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXFDBEX</th><th>unknown: </th><th>FA</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SSTINFO</th><th>unknown: </th><th>FE</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXVIEX</th><th>unknown: </th><th>101</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXPANE</th><th>unknown: </th><th>102</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SXFORMULAOLD</th><th>unknown: </th><th>121</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BIDIRESERVED</th><th>unknown: </th><th>131</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>VERSIONNUM</th><th>unknown: </th><th>136</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRINSDEL</th><th>unknown: </th><th>137</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRHEADER</th><th>unknown: </th><th>138</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRVERF</th><th>unknown: </th><th>139</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRITAB</th><th>unknown: </th><th>13A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRCHGCELL</th><th>unknown: </th><th>13B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRVERSIONLAST</th><th>unknown: </th><th>13C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRRENSHEET</th><th>unknown: </th><th>13E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRSORT</th><th>unknown: </th><th>13F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRMOVE</th><th>unknown: </th><th>140</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRCOPY</th><th>unknown: </th><th>141</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRFORMAT</th><th>unknown: </th><th>14A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRAUTOFMT</th><th>unknown: </th><th>14B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRDELETESH</th><th>unknown: </th><th>14C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRINSERTSH</th><th>unknown: </th><th>14D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRMOVEBEGIN</th><th>unknown: </th><th>14E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRMOVEEND</th><th>unknown: </th><th>14F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRINSDELBEGIN</th><th>unknown: </th><th>150</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRINSDELEND</th><th>unknown: </th><th>151</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRCONFLICT</th><th>unknown: </th><th>152</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRDEFNAME</th><th>unknown: </th><th>153</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRRSTETXP</th><th>unknown: </th><th>154</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>REVISIONEND</th><th>unknown: </th><th>15E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>LRNG</th><th>unknown: </th><th>15F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>XL5MODIFY</th><th>unknown: </th><th>162</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>USRSTMBEGIN</th><th>unknown: </th><th>190</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CUSR</th><th>unknown: </th><th>191</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CBUSR</th><th>unknown: </th><th>192</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>USR</th><th>unknown: </th><th>193</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RREXCLUSIVE</th><th>unknown: </th><th>194</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FILELOCK</th><th>unknown: </th><th>195</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRINFO</th><th>unknown: </th><th>196</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BCUSRS</th><th>unknown: </th><th>197</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>USRCHK</th><th>unknown: </th><th>198</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>USRSTMEND</th><th>unknown: </th><th>1A4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RRUSERVIEW</th><th>unknown: </th><th>1AC</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MSOTOOLBAR</th><th>unknown: </th><th>1B3</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MSOTOOLBARSET</th><th>unknown: </th><th>1B4</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>LEL</th><th>unknown: </th><th>1B9</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>OBNOMACROS</th><th>unknown: </th><th>1BD</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EXCEL9FILE</th><th>unknown: </th><th>1C0</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ENTEXU2</th><th>unknown: </th><th>1C2</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FBI2</th><th>Font Basis </th><th>1068</th></tr>
<tr> <td>4</td> <td>dmixBasis</td> <td>2</td> <td>Width of basis when font was applied</td></tr>
<tr> <td>6</td> <td>dmiyBasis</td> <td>2</td> <td>Height of basis when font was applied</td></tr>
<tr> <td>8</td> <td>twpHeightBasis</td> <td>2</td> <td>Font height applied</td></tr>
<tr> <td>10</td> <td>scab</td> <td>2</td> <td>Scale basis</td></tr>
<tr> <td>12</td> <td>ifnt</td> <td>2</td> <td>Index number into the font table</td></tr>
</table>

<table>
<tr><th>3D</th><th>Chart Group Is a 3-D Chart Group </th><th>103A</th></tr>
<tr> <td>4</td> <td>anRot</td> <td>2</td> <td>Rotation angle (0 to 360 degrees)</td></tr>
<tr> <td>6</td> <td>anElev</td> <td>2</td> <td>Elevation angle (90 to +90 degrees)</td></tr>
<tr> <td>8</td> <td>pcDist</td> <td>2</td> <td>Distance from eye to chart (0 to 100)</td></tr>
<tr> <td>10</td> <td>pcHeight</td> <td>2</td> <td>Height of plot volume relative to width anddepth</td></tr>
<tr> <td>12</td> <td>pcDepth</td> <td>2</td> <td>Depth of points relative to width</td></tr>
<tr> <td>14</td> <td>pcGap</td> <td>2</td> <td>Space between series</td></tr>
<tr> <td>16</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>AI</th><th>Linked Data </th><th>1051</th></tr>
<tr> <td>4</td> <td>id</td> <td>1</td> <td>Link index identifier0 = linking a series title or text1 = linking series values2 = linking series categories</td></tr>
<tr> <td>5</td> <td>rt</td> <td>1</td> <td>Reference type0 = use default categories1 = text or value entered directly into the formula bar2 = linked to worksheet3 = not used4 = error reported</td></tr>
<tr> <td>6</td> <td>grbit</td> <td>2</td> <td>Flags</td></tr>
<tr> <td>8</td> <td>ifmt</td> <td>2</td> <td>Index to number format record</td></tr>
<tr> <td>10</td> <td>cce</td> <td>2</td> <td>Size of rgce (in bytes)</td></tr>
<tr> <td>12</td> <td>rgce</td> <td>var</td> <td>Parsed formula of link</td></tr>
</table>

<table>
<tr><th>ALRUNS</th><th>Text Formatting </th><th>1050</th></tr>
<tr> <td>4</td> <td>cRuns</td> <td>2</td> <td>Number of rich-text runs</td></tr>
<tr> <td>6</td> <td>rgwRuns</td> <td>var</td> <td>Array of cRuns four-byte groups. The first two bytes in each group specify the first character in the rich-text run. The second two bytes specify the font index for the text run (see the FONT record for more information about this index).</td></tr>
</table>

<table>
<tr><th>AREA</th><th>Chart Group Is an Area Chart Group </th><th>101A</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>format flags</td></tr>
</table>

<table>
<tr><th>AREAFORMAT</th><th>Colors and Patterns for an Area </th><th>100A</th></tr>
<tr> <td>4</td> <td>rgbFore</td> <td>4</td> <td>Foreground color: RGB value (high byte = 0)</td></tr>
<tr> <td>8</td> <td>rgbBack</td> <td>4</td> <td>Background color: RGB value (high byte = 0)</td></tr>
<tr> <td>12</td> <td>fls</td> <td>2</td> <td>Pattern</td></tr>
<tr> <td>14</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
<tr> <td>16</td> <td>icvFore</td> <td>2</td> <td>Index to foreground color</td></tr>
<tr> <td>18</td> <td>icvBack</td> <td>2</td> <td>Index to background color</td></tr>
</table>

<table>
<tr><th>ATTACHEDLABEL</th><th>Series Data/Value Labels </th><th>100C</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Value label flags</td></tr>
</table>

<table>
<tr><th>AXESUSED</th><th>Number of Axes Sets </th><th>1046</th></tr>
<tr> <td>4</td> <td>cAxes</td> <td>2</td> <td>Number of axes sets</td></tr>
</table>

<table>
<tr><th>AXIS</th><th>Axis Type </th><th>101D</th></tr>
<tr> <td>4</td> <td>wType</td> <td>2</td> <td>Axis type0 = category axis or x axis on a scatterchart1 = value axis2 = series axis</td></tr>
<tr> <td>6</td> <td>(reserved)</td> <td>16</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>AXCEXT</th><th>Axis Options </th><th>1062</th></tr>
<tr> <td>4</td> <td>catMin</td> <td>2</td> <td>minimum category on axis</td></tr>
<tr> <td>6</td> <td>catMax</td> <td>2</td> <td>maximum category on axis</td></tr>
<tr> <td>8</td> <td>catMajor</td> <td>2</td> <td>value of major unit</td></tr>
<tr> <td>10</td> <td>duMajor</td> <td>2</td> <td>units of major unit</td></tr>
<tr> <td>12</td> <td>catMinor</td> <td>2</td> <td>value of minor unit</td></tr>
<tr> <td>14</td> <td>duMinor</td> <td>2</td> <td>units of minor unit</td></tr>
<tr> <td>16</td> <td>duBase</td> <td>2</td> <td>base unit of axis</td></tr>
<tr> <td>18</td> <td>catCrossDate</td> <td>2</td> <td>crossing point of value axis (date)</td></tr>
<tr> <td>20</td> <td>grbit</td> <td>2</td> <td>Option flags (see following table)</td></tr>
</table>

<table>
<tr><th>AXISLINEFORMAT</th><th>Defines a Line That Spans an Axis </th><th>1021</th></tr>
<tr> <td>4</td> <td>id</td> <td>2</td> <td>Axis line identifier:0 = the axis line itself1 = major grid line along the axis2 = minor grid line along the axis3 = walls or floor walls if parent axis is type 0 or 2; floor if parent axis is type 1</td></tr>
</table>

<table>
<tr><th>AXISPARENT</th><th>Axis Size and Location </th><th>1041</th></tr>
<tr> <td>4</td> <td>iax</td> <td>2</td> <td>Axis index (0 = main, 1 = secondary)</td></tr>
<tr> <td>6</td> <td>x</td> <td>4</td> <td>x coordinate of top left corner</td></tr>
<tr> <td>10</td> <td>y</td> <td>4</td> <td>y coordinate of top left corner</td></tr>
<tr> <td>14</td> <td>dx</td> <td>4</td> <td>length of x axis</td></tr>
<tr> <td>18</td> <td>dy</td> <td>4</td> <td>length of y axis</td></tr>
</table>

<table>
<tr><th>BAR</th><th>Chart Group Is a Bar or Column Chart Group </th><th>1017</th></tr>
<tr> <td>4</td> <td>pcOverlap</td> <td>2</td> <td>Space between bars (percent of bar width), default = 0</td></tr>
<tr> <td>6</td> <td>pcGap</td> <td>2</td> <td>Space between categories (percent of bar width), default = 50</td></tr>
<tr> <td>8</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
</table>

<table>
<tr><th>BOPPOP</th><th>Bar of Pie/Pie of Pie Chart Options </th><th>1061</th></tr>
<tr> <td>4</td> <td>pst</td> <td>1</td> <td>0 = normal pie chart1 = pie of pie chart2 = bar of pie chart</td></tr>
<tr> <td>5</td> <td>fAutoSplit</td> <td>1</td> <td>1 = use default split value</td></tr>
<tr> <td>6</td> <td>spit</td> <td>2</td> <td>Split type:0 = Position1 = Value2 = Percent3 = Custom</td></tr>
<tr> <td>8</td> <td>iSplitPos</td> <td>2</td> <td>For spit = 0, which positions should go to the other pie/bar</td></tr>
<tr> <td>10</td> <td>pcSplitPercent</td> <td>2</td> <td>For spit = 2, what percentage should go to the other bar/pie</td></tr>
<tr> <td>12</td> <td>pcPie2Size</td> <td>2</td> <td>Size of the second pie as a percentage of the first</td></tr>
<tr> <td>14</td> <td>pcGap</td> <td>2</td> <td>Space between the first pie and the second</td></tr>
<tr> <td>16</td> <td>numSplitValue</td> <td>4</td> <td>For spit = 1, what values should go to the other bar/pie</td></tr>
<tr> <td>20</td> <td>fHasShadow</td> <td>2</td> <td>1 = the second bar/pie has a shadow</td></tr>
</table>

<table>
<tr><th>BOPPOPCUSTOM</th><th>Custom Bar of Pie/Pie of Pie Chart Options </th><th>1067</th></tr>
<tr> <td>4</td> <td>cxi</td> <td>2</td> <td>Count of pie slices in the bar of pie or pie of pie chart</td></tr>
<tr> <td>6</td> <td>rggrbit</td> <td>var</td> <td>Array of bytes; each byte contains a bit field that describes the individual point positioning in the series. If a slice is on the secondary pie or bar chart, the corresponding bit is set to 1 (one); otherwise the bit is 0 (zero).</td></tr>
</table>

<table>
<tr><th>CATSERRANGE</th><th>Defines a Category or Series Axis </th><th>1020</th></tr>
<tr> <td>4</td> <td>catCross</td> <td>2</td> <td>Value axis/category crossing point (2-D charts only)</td></tr>
<tr> <td>6</td> <td>catLabel</td> <td>2</td> <td>Frequency of labels</td></tr>
<tr> <td>8</td> <td>catMark</td> <td>2</td> <td>Frequency of tick marks</td></tr>
<tr> <td>10</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
</table>

<table>
<tr><th>CHART</th><th>Location and Overall Chart Dimensions </th><th>1002</th></tr>
<tr> <td>4</td> <td>x</td> <td>4</td> <td>x-position of upper-left corner</td></tr>
<tr> <td>8</td> <td>y</td> <td>4</td> <td>y-position of upper-left corner</td></tr>
<tr> <td>12</td> <td>dx</td> <td>4</td> <td>x-size</td></tr>
<tr> <td>16</td> <td>dy</td> <td>4</td> <td>y-size</td></tr>
</table>

<table>
<tr><th>CHARTFORMAT</th><th>Parent Record for Chart Group </th><th>1014</th></tr>
<tr> <td>4</td> <td>(reserved)</td> <td>16</td> <td>Reserved; must be zero</td></tr>
<tr> <td>20</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
<tr> <td>22</td> <td>icrt</td> <td>2</td> <td>Drawing order (0 = bottom of the z-order)</td></tr>
</table>

<table>
<tr><th>CHARTFORMATLINK</th><th>Not Used </th><th>1022</th></tr>
<tr> <td>4</td> <td>data</td> <td>var</td> <td>format flags</td></tr>
</table>

<table>
<tr><th>CHARTLINE</th><th>Specifies Drop/Hi-Lo/Series Lines on a Line Chart </th><th>101C</th></tr>
<tr> <td>4</td> <td>id</td> <td>2</td> <td>Drop lines/hi-lo lines0 = drop lines1 = hi-lo lines2 = series lines (the lines that connect the columns in a stacked column chart)</td></tr>
</table>

<table>
<tr><th>DAT</th><th>Data Table Options </th><th>1063</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Option flags (see following table)</td></tr>
</table>

<table>
<tr><th>DATAFORMAT</th><th>Series and Data Point Numbers </th><th>1006</th></tr>
<tr> <td>4</td> <td>xi</td> <td>2</td> <td>Point number (FFFFh means entire series)</td></tr>
<tr> <td>6</td> <td>yi</td> <td>2</td> <td>Series index (file relative)</td></tr>
<tr> <td>8</td> <td>iss</td> <td>2</td> <td>Series number (as shown in name box S1, S2, etc.). This can be different from yi if the series order has been changed.</td></tr>
<tr> <td>10</td> <td>grbit</td> <td>2</td> <td>format flags</td></tr>
</table>

<table>
<tr><th>DEFAULTTEXT</th><th>Default Data Label Text Properties </th><th>1024</th></tr>
<tr> <td>4</td> <td>id</td> <td>2</td> <td>Object identifier for the text0 = default text characteristics for "show labels" data labels1 = default text characteristics for value and percentage data labels2 = default text characteristics for all text in thechart</td></tr>
</table>

<table>
<tr><th>DROPBAR</th><th>Defines Drop Bars </th><th>103D</th></tr>
<tr> <td>4</td> <td>pcGap</td> <td>2</td> <td>Drop bar gap width (0 to 100%)</td></tr>
</table>

<table>
<tr><th>FBI</th><th>Font Basis </th><th>1060</th></tr>
<tr> <td>4</td> <td>dmixBasis</td> <td>2</td> <td>Width of basis when font was applied</td></tr>
<tr> <td>6</td> <td>dmiyBasis</td> <td>2</td> <td>Height of basis when font was applied</td></tr>
<tr> <td>8</td> <td>twpHeightBasis</td> <td>2</td> <td>Font height applied</td></tr>
<tr> <td>10</td> <td>scab</td> <td>2</td> <td>Scale basis</td></tr>
<tr> <td>12</td> <td>ifnt</td> <td>2</td> <td>Index number into the font table</td></tr>
</table>

<table>
<tr><th>FONTX</th><th>Font Index </th><th>1026</th></tr>
<tr> <td>4</td> <td>ifont</td> <td>2</td> <td>Index number into the font table</td></tr>
</table>

<table>
<tr><th>FRAME</th><th>Defines Border Shape Around Displayed Text </th><th>1032</th></tr>
<tr> <td>4</td> <td>frt</td> <td>2</td> <td>0 = regular rectangle/no border1 3 (reserved)4 = rectangle with shadow</td></tr>
<tr> <td>6</td> <td>grbit</td> <td>2</td> <td>Flags</td></tr>
</table>

<table>
<tr><th>GELFRAME</th><th>Fill Data </th><th>1066</th></tr>
<tr> <td>4</td> <td>rgb</td> <td>var</td> <td>Reserved</td></tr>
</table>

<table>
<tr><th>IFMT</th><th>Number-Format Index </th><th>104E</th></tr>
<tr> <td>4</td> <td>ifmt</td> <td>2</td> <td>Number-format index (number of the FORMAT record in the BIFF, begins at zero)</td></tr>
</table>

<table>
<tr><th>LEGEND</th><th>Legend Type and Position </th><th>1015</th></tr>
<tr> <td>4</td> <td>x</td> <td>4</td> <td>x-position of upper-left corner</td></tr>
<tr> <td>8</td> <td>y</td> <td>4</td> <td>y-position of upper-left corner</td></tr>
<tr> <td>12</td> <td>dx</td> <td>4</td> <td>x-size</td></tr>
<tr> <td>16</td> <td>dy</td> <td>4</td> <td>y-size</td></tr>
<tr> <td>20</td> <td>wType</td> <td>1</td> <td>Type0 = bottom1 = corner2 = top3 = right4 = left7 = not docked or inside the plot area</td></tr>
<tr> <td>21</td> <td>wSpacing</td> <td>1</td> <td>Spacing0 = close1 = medium2 = open</td></tr>
<tr> <td>22</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>LEGENDXN</th><th>Legend Exception </th><th>1043</th></tr>
<tr> <td>4</td> <td>iss</td> <td>2</td> <td>Legend-entry index</td></tr>
<tr> <td>6</td> <td>grbit</td> <td>2</td> <td>Flags</td></tr>
</table>

<table>
<tr><th>LINE</th><th>Chart Group Is a Line Chart Group </th><th>1018</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>format flags</td></tr>
</table>

<table>
<tr><th>LINEFORMAT</th><th>Style of a Line or Border </th><th>1007</th></tr>
<tr> <td>4</td> <td>rgb</td> <td>4</td> <td>Color of line; RGB value high byte must be set to zero</td></tr>
<tr> <td>8</td> <td>lns</td> <td>2</td> <td>Pattern of line0 = solid1 = dash2 = dot3 = dash-dot4 = dash dot-dot5 = none6 = dark gray pattern7 = medium gray pattern8 = light gray pattern</td></tr>
<tr> <td>10</td> <td>we</td> <td>2</td> <td>Weight of line1 = hairline0 = narrow (single)1 = medium (double)2 = wide (triple)</td></tr>
<tr> <td>12</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
<tr> <td>14</td> <td>icv</td> <td>2</td> <td>Index to color of line</td></tr>
</table>

<table>
<tr><th>MARKERFORMAT</th><th>Style of a Line Marker </th><th>1009</th></tr>
<tr> <td>4</td> <td>rgbFore</td> <td>4</td> <td>Foreground color: RGB value (highbyte= 0)</td></tr>
<tr> <td>8</td> <td>rgbBack</td> <td>4</td> <td>Background color: RGB value (highbyte = 0)</td></tr>
<tr> <td>12</td> <td>imk</td> <td>2</td> <td>Type of marker0 = no marker1 = square2 = diamond3 = triangle4 = X5 = star6 = Dow-Jones7 = standard deviation8 = circle9 = plus sign</td></tr>
<tr> <td>14</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
<tr> <td>16</td> <td>icvFore</td> <td>2</td> <td>Index to color of marker border</td></tr>
<tr> <td>18</td> <td>icvBack</td> <td>2</td> <td>Index to color of marker fill</td></tr>
<tr> <td>20</td> <td>miSize</td> <td>4</td> <td>Size of line markers</td></tr>
</table>

<table>
<tr><th>OBJECTLINK</th><th>Attaches Text to Chart or to Chart Item </th><th>1027</th></tr>
<tr> <td>4</td> <td>wLinkObj</td> <td>2</td> <td>Object text is linked to1 = entire chart (chart title)2 = y axis (y axis title)3 = x axis (x axis title)4 = data series or data point (data label)5 not used6 not used7 = z axis (z axis title)</td></tr>
<tr> <td>6</td> <td>wLinkVar1</td> <td>2</td> <td>Link index 1, series number</td></tr>
<tr> <td>8</td> <td>wLinkVar2</td> <td>2</td> <td>Link index 2, data point number</td></tr>
</table>

<table>
<tr><th>PICF</th><th>Picture Format </th><th>103C</th></tr>
<tr> <td>4</td> <td>ptyp</td> <td>2</td> <td>Picture type:= 1, stretched= 2, stacked= 3, stacked and scaled</td></tr>
<tr> <td>6</td> <td>cf</td> <td>2</td> <td>Image format:= 2, Windows metafile or Macintosh PICT format= 9, Windows bitmap format</td></tr>
<tr> <td>8</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
<tr> <td>10</td> <td>numScale</td> <td>8</td> <td>Scaling value for pictures, units/picture (IEEEfloating-point number)</td></tr>
</table>

<table>
<tr><th>PIE</th><th>Chart Group Is a Pie Chart Group </th><th>1019</th></tr>
<tr> <td>4</td> <td>anStart</td> <td>2</td> <td>Angle of the first pie slice expressed in degrees</td></tr>
<tr> <td>6</td> <td>pcDonut</td> <td>2</td> <td>0 = true pie chartnon-zero = size of center hole in a donut chart (as a percentage)</td></tr>
<tr> <td>8</td> <td>grbit</td> <td>2</td> <td>Option flags (see following table)</td></tr>
</table>

<table>
<tr><th>PIEFORMAT</th><th>Position of the Pie Slice </th><th>100B</th></tr>
<tr> <td>4</td> <td>percent</td> <td>2</td> <td>Distance of pie slice from center of pie</td></tr>
</table>

<table>
<tr><th>PLOTGROWTH</th><th>Font Scale Factors </th><th>1064</th></tr>
<tr> <td>4</td> <td>dxPlotGrowth</td> <td>4</td> <td>Horizontal growth of plot area for font scaling</td></tr>
<tr> <td>8</td> <td>dyPlotGrowth</td> <td>4</td> <td>Vertical growth of plot area for font scaling</td></tr>
</table>

<table>
<tr><th>RADAR</th><th>Chart Group Is a Radar Chart Group </th><th>103E</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>RADARAREA</th><th>Chart Group Is a Radar Area Chart Group </th><th>1040</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>SBASEREF</th><th>PivotTable Reference </th><th>1048</th></tr>
<tr> <td>4</td> <td>rwFirst</td> <td>2</td> <td>First PivotTable row</td></tr>
<tr> <td>6</td> <td>rwLast</td> <td>2</td> <td>Last PivotTable row</td></tr>
<tr> <td>8</td> <td>colFirst</td> <td>2</td> <td>First PivotTable column</td></tr>
<tr> <td>10</td> <td>colLast</td> <td>2</td> <td>Last PivotTable column</td></tr>
</table>

<table>
<tr><th>SCATTER</th><th>Chart Group Is a Scatter Chart Group </th><th>101B</th></tr>
<tr> <td>4</td> <td>pcBubbleSizeRatio</td> <td>2</td> <td>Percent of largest bubble compared to chart in general</td></tr>
<tr> <td>6</td> <td>wBubbleSize</td> <td>2</td> <td>Bubble size:1 = bubble size is area2 = bubble size is width</td></tr>
<tr> <td>8</td> <td>grbit</td> <td>2</td> <td>Option flags (see following table)</td></tr>
</table>

<table>
<tr><th>SERAUXERRBAR</th><th>Series ErrorBar </th><th>105B</th></tr>
<tr> <td>4</td> <td>sertm</td> <td>1</td> <td>Error-bar type:1 = x-direction plus2 = x-direction minus3 = y-direction plus4 = y-direction minus</td></tr>
<tr> <td>5</td> <td>ebsrc</td> <td>1</td> <td>Error-bar value source:1 = percentage2 = fixed value3 = standard deviation4 = custom5 = standard error</td></tr>
<tr> <td>6</td> <td>fTeeTop</td> <td>1</td> <td>TRUE if the error bars are T-shaped (have a line on the top and bottom)</td></tr>
<tr> <td>7</td> <td>(reserved)</td> <td>1</td> <td>Reserved; must be 1</td></tr>
<tr> <td>8</td> <td>numValue</td> <td>8</td> <td>IEEE number; specifies the fixed value, percentage, or number of standard deviations for the error bars</td></tr>
<tr> <td>16</td> <td>cnum</td> <td>2</td> <td>Number of values or cell references used for custom error bars</td></tr>
</table>

<table>
<tr><th>SERAUXTREND</th><th>Series Trendline </th><th>104B</th></tr>
<tr> <td>4</td> <td>regt</td> <td>1</td> <td>Regression type:0 = polynomial1 = exponential2 = Logarithmic3 = Power4 = moving average(a linear trendline has type 0 with order 1)</td></tr>
<tr> <td>5</td> <td>ordUser</td> <td>1</td> <td>Polynomial order or moving average period</td></tr>
<tr> <td>6</td> <td>numIntercept</td> <td>8</td> <td>IEEE number; specifies forced intercept (#NA if no intercept is specified)</td></tr>
</table>

<table>
<tr><th>SERFMT</th><th>Series Format </th><th>105D</th></tr>
<tr> <td>0</td> <td>grbit</td> <td>2</td> <td>flags</td></tr>
</table>

<table>
<tr><th>SERIES</th><th>Series Definition </th><th>1003</th></tr>
<tr> <td>4</td> <td>sdtX</td> <td>2</td> <td>Type of data in categories0 = categories contain date information (not used)1 = categories contain numeric information2 = categories contain sequence information (not used)3 = categories contain text information</td></tr>
<tr> <td>8</td> <td>sdtY</td> <td>2</td> <td>Type of data in values0 = values contain date information (not used)1 = values contain numeric information2 = values contain sequence information (not used)3 = values contain text information</td></tr>
<tr> <td>10</td> <td>cValx</td> <td>2</td> <td>Count of categories</td></tr>
<tr> <td>12</td> <td>cValy</td> <td>2</td> <td>Count of values</td></tr>
<tr> <td>14</td> <td>sdtBSize</td> <td>2</td> <td>Type of data in Bubble size series:0 = dates1 = numeric2 = sequence3 = text</td></tr>
<tr> <td>16</td> <td>cValBSize</td> <td>2</td> <td>Count of Bubble series values</td></tr>
</table>

<table>
<tr><th>SERIESLIST</th><th>Specifies the Series in an Overlay Chart </th><th>1016</th></tr>
<tr> <td>4</td> <td>cser</td> <td>2</td> <td>Count of series (size of rgiser)</td></tr>
<tr> <td>6</td> <td>rgiser</td> <td>var</td> <td>List of series numbers (words)</td></tr>
</table>

<table>
<tr><th>SERIESTEXT</th><th>Legend/Category/Value Text </th><th>100D</th></tr>
<tr> <td>4</td> <td>id</td> <td>2</td> <td>Text identifier:0 = series name or text</td></tr>
<tr> <td>6</td> <td>cch</td> <td>1</td> <td>Length of text field</td></tr>
<tr> <td>7</td> <td>rgch</td> <td>var</td> <td>The series text string</td></tr>
</table>

<table>
<tr><th>SERPARENT</th><th>Trendline or ErrorBar Series Index </th><th>104A</th></tr>
<tr> <td>4</td> <td>series</td> <td>2</td> <td>Series index for the series that the trendline or error bar is attached to</td></tr>
</table>

<table>
<tr><th>SERTOCRT</th><th>Series Chart-Group Index </th><th>1045</th></tr>
<tr> <td>0</td> <td>chartgroup</td> <td>2</td> <td>Chart-group index</td></tr>
</table>

<table>
<tr><th>SHTPROPS</th><th>Sheet Properties </th><th>1044</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Property flags</td></tr>
<tr> <td>6</td> <td>mdBlank</td> <td>1</td> <td>Empty cells plotted as:0 = not plotted1 = zero2 = interpolated</td></tr>
</table>

<table>
<tr><th>SIINDEX</th><th>Series Index </th><th>1065</th></tr>
<tr> <td>4</td> <td>numIndex</td> <td>4</td> <td>Index into series list</td></tr>
</table>

<table>
<tr><th>SURFACE</th><th>Chart Group Is a Surface Chart Group </th><th>103F</th></tr>
<tr> <td>4</td> <td>grbit</td> <td>2</td> <td>Option flags</td></tr>
</table>

<table>
<tr><th>TEXT</th><th>Defines Display of Text Fields </th><th>1025</th></tr>
<tr> <td>4</td> <td>at</td> <td>1</td> <td>Horizontal alignment of the text (1 = left, 2 = center, 3 = bottom, 4 = justify)</td></tr>
<tr> <td>5</td> <td>vat</td> <td>1</td> <td>Vertical alignment of the text (1 = top, 2 = center, 3 = bottom, 4 = justify)</td></tr>
<tr> <td>6</td> <td>wBkgMode</td> <td>2</td> <td>Display mode of the background1 = transparent2 = opaque</td></tr>
<tr> <td>8</td> <td>rgbText</td> <td>4</td> <td>Color of the text; RGB value (high byte = 0)</td></tr>
<tr> <td>12</td> <td>x</td> <td>4</td> <td>x-position of the text in 1/4000 of chart area</td></tr>
<tr> <td>16</td> <td>y</td> <td>4</td> <td>y-position of the text in 1/4000 of chart area</td></tr>
<tr> <td>20</td> <td>dx</td> <td>4</td> <td>x-size of the text in 1/4000 of chart area</td></tr>
<tr> <td>24</td> <td>dy</td> <td>4</td> <td>y-size of the text in 1/4000 of chart area</td></tr>
<tr> <td>28</td> <td>grbit</td> <td>2</td> <td>Option flags (See following table)</td></tr>
<tr> <td>30</td> <td>icvText</td> <td>2</td> <td>Index to color value of text</td></tr>
<tr> <td>32</td> <td>grbit2</td> <td>2</td> <td>Option flags (See following table)</td></tr>
<tr> <td>34</td> <td>trot</td> <td>2</td> <td>Text rotation:0dec = Horizontal90dec = Up 90180dec = Down 180-90dec = Down (inverted from 180dec)</td></tr>
</table>

<table>
<tr><th>TICK</th><th>Tick Marks and Labels Format </th><th>101E</th></tr>
<tr> <td>4</td> <td>tktMajor</td> <td>1</td> <td>Type of major tick mark0 = invisible (none)1 = inside of axis line2 = outside of axis line3 = cross axis line</td></tr>
<tr> <td>5</td> <td>tktMinor</td> <td>1</td> <td>Type of minor tick mark0 = invisible (none)1 = inside of axis line2 = outside of axis line3 = cross axis line</td></tr>
<tr> <td>6</td> <td>tlt</td> <td>1</td> <td>Tick label position relative to axis line0 = invisible (none)1 = low end of plot area2 = high end of plot area3 = next to axis</td></tr>
<tr> <td>7</td> <td>wBkgMode</td> <td>1</td> <td>Background mode:1 = transparent2 = opaque</td></tr>
<tr> <td>8</td> <td>rgb</td> <td>4</td> <td>Tick-label text color; RGB value, highbyte = 0</td></tr>
<tr> <td>12</td> <td>(reserved)</td> <td>16</td> <td>Reserved; must be zero</td></tr>
<tr> <td>28</td> <td>grbit</td> <td>2</td> <td>Display flags</td></tr>
<tr> <td>30</td> <td>icv</td> <td>2</td> <td>Index to color of tick label</td></tr>
<tr> <td>32</td> <td>(reserved)</td> <td>2</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>UNITS</th><th>Chart Units </th><th>1001</th></tr>
<tr> <td>4</td> <td>wUnits</td> <td>2</td> <td>Always zero</td></tr>
</table>

<table>
<tr><th>VALUERANGE</th><th>Defines Value Axis Scale </th><th>101F</th></tr>
<tr> <td>4</td> <td>numMin</td> <td>8</td> <td>Minimum value on axis</td></tr>
<tr> <td>12</td> <td>numMax</td> <td>8</td> <td>Maximum value on axis</td></tr>
<tr> <td>20</td> <td>numMajor</td> <td>8</td> <td>Value of major increment</td></tr>
<tr> <td>28</td> <td>numMinor</td> <td>8</td> <td>Value of minor increment</td></tr>
<tr> <td>36</td> <td>numCross</td> <td>8</td> <td>Value where category axis crosses</td></tr>
<tr> <td>44</td> <td>grbit</td> <td>2</td> <td>Format flags</td></tr>
</table>

<table>
<tr><th>POS</th><th>Position Information </th><th>104F</th></tr>
<tr> <td>4</td> <td>mdTopLt</td> <td>2</td> <td>Must be 2</td></tr>
<tr> <td>6</td> <td>mdBotRt</td> <td>2</td> <td>Must be 2</td></tr>
<tr> <td>8</td> <td>x1</td> <td>4</td> <td>x coordinate of bounding box top left corner</td></tr>
<tr> <td>12</td> <td>y1</td> <td>4</td> <td>y coordinate of bounding box top left corner</td></tr>
<tr> <td>16</td> <td>x2</td> <td>4</td> <td>width of the bounding box</td></tr>
<tr> <td>20</td> <td>y2</td> <td>4</td> <td>height of the bounding box</td></tr>
</table>

<table>
<tr><th>CHARTMIN</th><th>unknown: </th><th>1000</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DATALINK</th><th>unknown: </th><th>1004</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PARSEINFO</th><th>unknown: </th><th>1005</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>BF</th><th>unknown: </th><th>1008</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DATASEQUENCE</th><th>unknown: </th><th>100E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DATASCALE</th><th>unknown: </th><th>100F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TIMEUNIT</th><th>unknown: </th><th>1010</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SERIESFORMULA</th><th>unknown: </th><th>1011</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DATALABELFORMAT</th><th>unknown: </th><th>1012</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>FORMATINDEX</th><th>unknown: </th><th>1013</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTFORMATSELECTION </th><th>unknown: </th><th>1023</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EXTERNALLINK</th><th>unknown: </th><th>1028</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TEXTROTATION</th><th>unknown: </th><th>1029</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TEXTSCALE</th><th>unknown: </th><th>102A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TEXTBULLET</th><th>unknown: </th><th>102B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>PICTURE</th><th>unknown: </th><th>102C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ARROW</th><th>unknown: </th><th>102D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ARROWLINK</th><th>unknown: </th><th>102E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ARROWHEAD</th><th>unknown: </th><th>102F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTLINK</th><th>unknown: </th><th>1030</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTSELECTION</th><th>unknown: </th><th>1031</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTSIZE</th><th>unknown: </th><th>1036</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>RELATIVEPOSITION</th><th>unknown: </th><th>1037</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ARROWRELATIVEPOSITION</th><th>unknown: </th><th>1038</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DLTEXT</th><th>unknown: </th><th>1039</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>REFST</th><th>unknown: </th><th>103B</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CRTAXIS</th><th>unknown: </th><th>1042</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>DTVISIBLE</th><th>unknown: </th><th>1047</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SERFIRSTCHILD</th><th>unknown: </th><th>1049</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>UNLINKEDIFMT</th><th>unknown: </th><th>104D</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>SSBOF</th><th>unknown: </th><th>1052</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EXCLUDEROWS</th><th>unknown: </th><th>1053</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>EXCLUDECOLS</th><th>unknown: </th><th>1054</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>ORIENT</th><th>unknown: </th><th>1055</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>IMPORT</th><th>unknown: </th><th>1056</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>WINDOC</th><th>unknown: </th><th>1057</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MAXSTATUS</th><th>unknown: </th><th>1058</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>MAINWINDOW</th><th>unknown: </th><th>1059</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>TARGPRINTER</th><th>unknown: </th><th>105A</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CLRTCLIENT</th><th>unknown: </th><th>105C</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>LINKSEL</th><th>unknown: </th><th>105E</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>3DBARSHAPE</th><th>unknown: </th><th>105F</th></tr>
<tr> <td>4</td> <td>Unknown</td> <td>var</td> <td>No definition</td></tr>
</table>

<table>
<tr><th>CHARTFRTINFO</th><th>Chart Future Record Type Info </th><th>850</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0850h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>verOriginator</td> <td>1</td> <td>Excel version that originally created the file</td></tr>
<tr> <td>9 </td> <td>verWriter</td> <td>1</td> <td>Excel version that last saved the file</td></tr>
<tr> <td>10 </td> <td>cCFRTID</td> <td>2</td> <td>Count of FRT ID value ranges in list</td></tr>
<tr> <td>12 </td> <td>rgCFRTID</td> <td>var</td> <td>List of FRT ID values used for charts</td></tr>
</table>

<table>
<tr><th>FRTWRAPPER</th><th>Chart Future Record Type Wrapper </th><th>851</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0851h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>rt</td> <td>2</td> <td>RT of wrapped record</td></tr>
<tr> <td>10 </td> <td>cb</td> <td>2</td> <td>Size of wrapped RT's data in bytes</td></tr>
<tr> <td>12 </td> <td>rgb</td> <td>var</td> <td>RT's data</td></tr>
</table>

<table>
<tr><th>STARTBLOCK</th><th>Chart Future Record Type Start Block </th><th>852</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0852h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>iObjectKind</td> <td>2</td> <td>See table below</td></tr>
<tr> <td>10 </td> <td>iObjectContext</td> <td>2</td> <td>See table below</td></tr>
<tr> <td>12 </td> <td>iObjectInstance1</td> <td>2</td> <td>See table below</td></tr>
<tr> <td>14 </td> <td>iObjectInstance2</td> <td>2</td> <td>See table below</td></tr>
</table>

<table>
<tr><th>ENDBLOCK</th><th>Chart Future Record Type End Block </th><th>853</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0853h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>iObjectKind</td> <td>2</td> <td>Sanity check for object scope being ended</td></tr>
<tr> <td>10 </td> <td>(unused)</td> <td>6</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>STARTOBJECT</th><th>Chart Future Record Type Start Object </th><th>854</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0854h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>iObjectKind</td> <td>2</td> <td>Kinds of object, e.g., AI, CRT, SS, etc.</td></tr>
<tr> <td>10 </td> <td>iObjectContext</td> <td>2</td> <td>Where the object lives, object-specific</td></tr>
<tr> <td>12 </td> <td>iObjectInstance1</td> <td>2</td> <td>Which one from a collection, object-specific</td></tr>
<tr> <td>14 </td> <td>iObjectInstance2</td> <td>2</td> <td>Which one from a collection, object-specific.</td></tr>
</table>

<table>
<tr><th>ENDOBJECT</th><th>Chart Future Record Type End Object </th><th>855</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0855h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
</table>

<table>
<tr><th>CATLAB</th><th>Category Labels </th><th>856</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0856h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>10 </td> <td>wOffset</td> <td>2</td> <td>Distance between category label levels</td></tr>
<tr> <td>12 </td> <td>at</td> <td>2</td> <td>Category axis label alignment</td></tr>
<tr> <td>14 </td> <td>grbit</td> <td>2</td> <td>Option flags for category axis labels (see description below)</td></tr>
<tr> <td>16 </td> <td>(unused)</td> <td>2</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>YMULT</th><th>Y Multiplier </th><th>857</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0857h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
</table>

<table>
<tr><th>SXVIEWLINK</th><th>Chart PivotTable Name </th><th>858</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0858h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>brst</td> <td>var</td> <td>String containing name of PivotTable</td></tr>
</table>

<table>
<tr><th>PIVOTCHARTBITS</th><th>PivotChart Bits </th><th>859</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0859h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>grbit</td> <td>2</td> <td>Option flags for PivotCharts (see description below)</td></tr>
<tr> <td>10 </td> <td>(unused)</td> <td>6</td> <td>Reserved; must be zero</td></tr>
</table>

<table>
<tr><th>FRTFONTLIST</th><th>Chart Font List </th><th>85A</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =085Ah</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>verChart</td> <td>1</td> <td>Version of Charting this list applies to</td></tr>
<tr> <td>9 </td> <td>cfont</td> <td>2</td> <td>Number of fonts in list</td></tr>
<tr> <td>11 </td> <td>rgFontInfo</td> <td>var</td> <td>Array of font IDs</td></tr>
</table>

<table>
<tr><th>PIVOTCHARTLINK</th><th>Pivot Chart Link </th><th>861</th></tr>
<tr> <td>4 </td> <td>rt</td> <td>2</td> <td>Record type; this matches the BIFF rt in the first two bytes of the record; =0861h</td></tr>
<tr> <td>6 </td> <td>grbitFrt</td> <td>2</td> <td>FRT flags; must be zero</td></tr>
<tr> <td>8 </td> <td>ai</td> <td>var</td> <td>same as AI record</td></tr>
</table>

<h1>got 518 records</h1><h1>517 unique</h1>
